查询某字段不重复记录的SQL语句该如何写

2013-08-24

查询某字段不重复记录的SQL语句该怎么写？select name,age from users group by name having count(*) 1

查询某字段不重复记录的SQL语句该怎么写？
select name,age from users group by name having count(*) = 1;