想得到各级汇总

[lysoon]

我想得到各级汇总
表结构如下
subno,subname,debit,credit
10 现金 10
1001 银行存款 100
。。。
我想得到subno长度为2，4，6，。。。的debit,credit汇总数

[伍子V5]

select subno,sum(debit),sum(credit) from tablename where len(cast( subno as varchar)) in (2,4,6)

[maoyesky]

select len(subno) as 長度,sum(debit) as debit,sum(credit) as credit from tablename group by len(subno)

[Dennis618]

select len(subno),sum(debit),sum(credit) from table group by len(subno)

[lysoon]

不仅仅是长度是2，4，
例如长度是2的有10，现金；20 ，银行存款
这时就得统计10，20 的汇总数

[lysoon]

有高手吗

[lysoon]

真的没人会吗

[quanyi]

select len(subno) as 長度,sum(debit) as debit,sum(credit) as credit from tablename group by 長度