Question

SQL中怎样查询一列中的唯一值

一列中有1,2,2,2,3,4,5,6,6,6,6,6,7,7,8,8,9,9我只想查出没有重复数字的,怎么查,就是1,3,4,5.

Answer 1

select 列名 from table_name group by 列名 having count(*)=1

Answer 2

select distinct 列名 from tablexxx;