oracle如何查出相同列的所有數(shù)據(jù)?
select * from XX t where t.唯一值的字段名 in (select t1.唯一值的字段名 from XX t1 group by 唯一值的字段名 having count(*) >1
)
上一篇什么級別的程序員最好
oracle如何查出相同列的所有數(shù)據(jù)?
select * from XX t where t.唯一值的字段名 in (select t1.唯一值的字段名 from XX t1 group by 唯一值的字段名 having count(*) >1
)