select * from table group by name having count(*)>1
SELECT name FROM table11 GROUP BY name HAVING (COUNT(*) > 1) 谢谢大家
select * into temp_table from name group by name Having(count(*)>1) select * from name inner join temp_table on name.name = temp_table.name order by name.name 最好写入到临时表中要好!;)
select name from table group by name having count(name)>1
1: select name from table group by name having count(name)>1
FROM table11
GROUP BY name
HAVING (COUNT(*) > 1)
谢谢大家
select * from name inner join temp_table on name.name = temp_table.name order by name.name
最好写入到临时表中要好!;)
select name from table group by name having count(name)>1