求一sql语句的写法

来源：百度知道编辑：UC知道时间：2024/06/25 09:44:44

表名yj 某字段ip，表里有大量数据，我只想把ip重复出现2次以上的数据全部输出，sql该如何写呢

select ip from yi group by ip having count(ip)>1;
楼上的兄弟你错了~~哈哈

SELECT * FROM yj GROUP BY ip HAVING COUNT(ip)>2;
---------------------------------------
呵呵，谢谢hero指正，楼主请改成>1

select a.ip from yj a join (
select ip from yj group by ip
having count(ip)>1) b
on a.ip=b.ip
order by a.ip