--这样? select id,name from GS_ZCXX_2012 group by id,name having count(*)>1
select * from ( select id,name,row_number(partition by id,name order by number) rn from GS_ZCXX_2012 ) where rn > 1
失误 打掉了个 好久没怎么回 都忘记咯select * from ( select id,name,row_number() over(partition by id,name order by number) rn from GS_ZCXX_2012 ) where rn > 1
oracle的语法就是这样,通用的sql是 select a.* from GS_ZCXX_2012 a, (select id,name,count(*) num from GS_ZCXX_2012 group by id,name having count(*) >1 ) b where a.id =b.id and a.name =b.name
select * from GS_ZCXX_2012 where rowid in (select rowid from GS_ZCXX_2012 group by id,name having count(*)>1)
--这样?
select id,name from GS_ZCXX_2012 group by id,name having count(*)>1
select *
from
(
select id,name,row_number(partition by id,name order by number) rn
from GS_ZCXX_2012
)
where rn > 1
from
(
select id,name,row_number() over(partition by id,name order by number) rn
from GS_ZCXX_2012
)
where rn > 1
select a.* from GS_ZCXX_2012 a,
(select id,name,count(*) num from GS_ZCXX_2012
group by id,name having count(*) >1 ) b
where a.id =b.id and a.name =b.name
select * from GS_ZCXX_2012 where rowid in (select rowid from GS_ZCXX_2012 group by id,name having count(*)>1)