如果我查询student表中userid字段相同的记录数大于2的name该怎么写啊
select name from (select count(userid) as c , name from table1 group by name) where c >='2'
这样写可以吗
select name from (select count(userid) as c , name from table1 group by name) where c >='2'
这样写可以吗
调试欢乐多
WHERE A.userid=B.userid
AND A.ROWID<>B.ROWID
只对ORACLE有效
select name from table group by name having count(*) > 2
---------- ----------
1 ggg
1 hhh
2 uuu
3 eee
3 uyy
SQL> select id from test group by id having count(*)>1; ID
----------
1
3
有什么错误???哪里有错误呀