求sql查询语句写法

[lingy]

有一个table表字段table1
记录为（1，1，2，2，3，3，4，5，6，6，7，8，8，9）
我想统计出记录值不重复的记录条数目，例子的结果应该是4

[mathematician]

字段名为a:
SELECT MIN(a) as a FROM table_name GROUP by a HAVING COUNT(*)=1;

[lingy]

数学家)这样不行，我也是这么写的，但是我不要返回4条记录，我只要返回一行，得出结果

[陈年椰子]

不支持子查询， 的确有点郁闷

[lingy]

4.1以上不是支持子查询吗？

[lingy]

select count(num) from (select count(table1) as num from table group by table1 having count(table1)=1) as b

唉，自己搞定了，谢谢各位了

[pumawang]

select count(distinct field1) from table

[skystar2001]

select count(*) from (select distinct num,count(num) as bb from aaa group by num having count(num)=1) as b;