select name, type, sum(sen) as sen, sum(min) as min, sum(fee) as fee from tablename having area like 'TW' group by name, type union select name, type, sum(sen) as sen, sum(min) as min, sum(fee) as fee from tablename having area like 'bj' group by name, type union .... 即可.
select name, type,area, sum(sen) as sen, sum(min) as min, sum(fee) as fee from tablename group by name,area, type 这样不行吗我看你的表结构中有area这个字段阿如果是在dbgrid中不显示出来很容易做到的阿
从 ... type area ... b_1 cn,bj b_1 tw,gx b_1 tw,gx 变成 ... type area ... b_1 cn,gz b_1 HK这里看不懂的说
select name, type, area, sum(sen) as sen, sum(min) as min, sum(fee) as fee from tablename group by name, type, area order by name,type这样不可以吗?
什么意思阿?
from tablename
having area like 'TW'
group by name, type
union
select name, type, sum(sen) as sen, sum(min) as min, sum(fee) as fee
from tablename
having area like 'bj'
group by name, type
union ....
即可.
from tablename
group by name,area, type
这样不行吗我看你的表结构中有area这个字段阿如果是在dbgrid中不显示出来很容易做到的阿
... type area ...
b_1 cn,bj
b_1 tw,gx
b_1 tw,gx 变成
... type area ...
b_1 cn,gz
b_1 HK这里看不懂的说
from tablename
group by name, type, area
order by name,type这样不可以吗?