WITH SQL AS ( SELECT 1 AS id,'name' AS NAME FROM dual UNION ALL SELECT 2,'name'FROM dual UNION ALL SELECT 2,'ss' FROM dual ) SELECT * FROM SQL WHERE NAME IN (SELECT NAME FROM SQL GROUP BY NAME HAVING COUNT(ID)>=2) id name 2 name 1 name
select * from table_name where (select count(*) from table_name)>1
select * from table_name where exits(select * from table_name group by 字段 having count(字段)>1)order by 字段
select * from table_name where exits(select * from table_name group by 字段 having count(字段)>1)order by 字段
select 字段 from 表 group by 字段 having count(*)>1
SELECT NAME FROM TABLE GROUP BY NAME HAVING COUNT(ID)>1
select * from table_name a,table_name b where a.name = b.name and a.rowid <> b.rowid这样行么?
WITH SQL AS
(
SELECT 1 AS id,'name' AS NAME FROM dual UNION ALL
SELECT 2,'name'FROM dual UNION ALL
SELECT 2,'ss' FROM dual
)
SELECT * FROM SQL WHERE NAME IN (SELECT NAME FROM SQL GROUP BY NAME HAVING COUNT(ID)>=2)
id name
2 name
1 name
select *
from table_name
where (select count(*) from table_name)>1
group by 字段 having count(字段)>1)order by 字段
group by 字段 having count(字段)>1)order by 字段
where a.name = b.name
and a.rowid <> b.rowid这样行么?