方法一:Distinct
SELECT DISTINCT ColName FROM TableName
方法二:Group By
SELECT ColName FROM TableName GROUP BY ColName
更多内容:
查询并统计该字段的数量
SELECT ColName,COUNT(COlName) FROM TableName GROUP BY ColName
方法一:Distinct
SELECT DISTINCT ColName FROM TableName
方法二:Group By
SELECT ColName FROM TableName GROUP BY ColName
SELECT ColName,COUNT(COlName) FROM TableName GROUP BY ColName