如果按在数据库中的次数选择

[Dabay]

比如表是这样的

number
--------
one
two
three
one
three
one
--------

我想得到这样的结果

---------
one 3
three 2
two 1
---------

后面的数据表示在表中出现的次数. 谢谢!!!

[lxzm1001]

select number,count(*) from tablename group by number

[blackbinbin]

select number ,count(*) from tablename group by number

[Dabay]

select number,count(*) as counter from tablename group by number order by counter desc