巨麻烦的sql问题，求助

[zcwok]

数据库表table的一个字段为number,现在要求分别计算出number值不同的纪录的数量，并显示出来。请问，怎么做效率最高。

[zcwok]

已经解决。每人都有分。呵呵

[kknew]

select number,count(*) as value group by number

[付长松_华为云MVP]

select count(number) as yourcount group by number

[einsteincao]

take it easy! use the method here:
select count(distinct(table.number)) as xxx
from table

[acewang]

select count(number) as yourcount group by number

[大健]

SELECT SUM(1)
FROM (SELECT 1 from [table] GROUP BY [number]) a

[goody9807]

select count(number) as yourcount group by number

[zcwok]

不要嫌我笨阿。这个sql语句，我也是知道的，但是怎么把结果都显示出来呢。

string strSQL="....";
OleDbDataAdapter myDA=new OleDbDataAdapter(strSQL,Conn);
下边怎么做，能吧结果显示在一个lbl控件中，如：
number为1的xx本，number为2的xx本，等等。

[alangSun]

你可以把这个语句结果作为一个记录集，然后把他放在datagrid里呀，

[lwgj]

select count(distinct(table.number)) as n from table