SQL中分类显示且重新编号

[Vinker]

Table中有这几个字段：Class Name Status，现在是就是想要根据class去分类，并且class单独为一行，在每个class下面跟着的就是NO、Name和status，显示为以下结构：
OneClass
No. Name Status
1 Officials Non-statutory
2 Development Non-statutory
TwoClass
No. Name Status
1 Board Statutory
2 Committee Non-statutory
3 Honours Non-statutory
4 ICAC Complaints Committee Non-statutory
ThreeClass
No. Name Status
1 ICAC Non-statutory
2 Citizens Non-statutory
3 Corruption statutory

[AcHerat]

最好把表结构和数据都拿出来，需要的结果格式弄好。

[唐诗三百首]

declare @sql varchar(5000)

select @sql='select '''+Class+''','''','''' union all ' +
            'select rownumber over(order by name) NO,Name,status from tab where class='''+Class+''' union all '
from
(select distinct Class from tab) t

exec(@sql)

[--小F--]

像你这样的格式最好到报表里面去做。