select * from <table> where name in ( select name from <table> group by name having count(*) > 1 )
oracle 下楼上老大的写法是对的 SQL> select * from temp;ID NAME PASSWORD ---------- ---------- ---------- 样本出 1 yangbc ybwo 1 yangbc ybcs 1 yangbc 9825132SQL> insert into temp values('1','yang','sdf5132');已创建 1 行。SQL> select * from temp;ID NAME PASSWORD ---------- ---------- ---------- 样本出 1 yangbc ybwo 1 yangbc ybcs 1 yangbc 9825132 1 yang sdf5132SQL> select * from temp where name in 2 (select name from temp group by name having count(*)>1);ID NAME PASSWORD ---------- ---------- ---------- 1 yangbc ybcshiwo 1 yangbc ybcs 1 yangbc 9825132SQL>
select * from t aa where (select count(*) from t where 列名=aa.列名)>1
(
select name from <table> group by name having count(*) > 1
)
SQL> select * from temp;ID NAME PASSWORD
---------- ---------- ----------
样本出
1 yangbc ybwo
1 yangbc ybcs
1 yangbc 9825132SQL> insert into temp values('1','yang','sdf5132');已创建 1 行。SQL> select * from temp;ID NAME PASSWORD
---------- ---------- ----------
样本出
1 yangbc ybwo
1 yangbc ybcs
1 yangbc 9825132
1 yang sdf5132SQL> select * from temp where name in
2 (select name from temp group by name having count(*)>1);ID NAME PASSWORD
---------- ---------- ----------
1 yangbc ybcshiwo
1 yangbc ybcs
1 yangbc 9825132SQL>
where (select count(*) from t where 列名=aa.列名)>1