1
1
2
3
4
5
5
要求分别查询出值为(2,3,4)和值为(1,5)
sql语句分别为:
select sno from aaa where sno in(select sno from aaa group by sno having count(*)=1)
显示结果sno(2,3,4)
select sno from aaa where sno in(select sno from aaa group by sno having count(*)!=1)
显示结果sno(1,5)
原文地址:http://blog.sina.com.cn/s/blog_5ced23750100bh33.html