请问如何统计某列相同值的个数？

Question

表中的记录为：
ID                        VALUE
1000000000                1
1000000001                1
1000000002                1
1000000003                2
1000000004                1
1000000005                2
1000000006                3
1000000007                3
1000000008                3
1000000009                1想得到这样的结果VALUE                     COUNT
1                         5
2                         2
3                         3这个要怎么做呢？

Answer 1

select value,count(*) from table group by value;