SQL查询唯一 把重复的都去掉

[哈米坨坨]

table1
id step
1 1
1 2
2 1
2 2
3 1

输出 所有ID不重复的
ID=3

[dawugui]

[Quote=引用楼主 eremen 的帖子:]
table1
id step
1 1
1 2
2 1
2 2
3 1

输出 所有ID不重复的
ID=3
[/Quote]

select id from tb group by id having count(*) = 1

[正宗老冉]

用 DISTINCT 行不？

[Limpire]

select id from table1 group by id having count(*) = 1

[zarge]

select * from table1 t where ( select count(*) from table1 where id = t.id ) = 1

[哈米坨坨]

1楼很强大 谢谢