前100条问题！！大家来看看

[duskfox2]

如何分组统计前100条记录！
set top 1000* from 表A group by 字段1
为什么不行

[liuri璇玑]

select 字段1,...,
from (select top 100 * from 表A) a group by 字段1

[liuri璇玑]

你那样应该是统计分组后的100条记录吧

[duskfox2]

是统计前100记录中分组的情况！你那种方法我试过好像不行！

[OpenVMS]

select * from 表A group by 字段1 having count(*)<=100

[OpenVMS]

每组100条以内
select * from 表A group by 字段1 having count(*)<=100
对前100记录分组
select 字段1,max(字段1)...
from (select top 100 * from 表A) b

[CrazyFor]

set col1 from (select top 100 * from 表A)AA group by 字段1

[duskfox2]

select 字段1,...,
from (select top 100 * from 表A) a group by 字段1
为什么from 后面还要表a