查询某一字段的值在数据表中出现的次数

[haona]

某一字段的值在数据表中出现的次数。例如查询只出现1次的这些记录，用sql怎么查询。

[lencon]

select count(字段) FROM TABLENAME GROUP BY 字段 HAVING COUNT(*)=1

[边城无名]

select *,count(*) FROM <数据表> GROUP BY <字段> HAVING COUNT(*)=1

[ekekyn]

用sql最方便了

[yesyesyes]

select count(*) FROM <数据表> where <字段>=<你要的值> GROUP BY <字段> HAVING COUNT(*)=1

[lencon]

select count(字段) FROM TABLENAME GROUP BY 字段 HAVING COUNT(*)=1
正确

[xclzteb]

楼上可以了。