在MS SQL SERVER ,已item的整数为分组,取min(item)和min(ivoice_id)这样可以取得除description外的数据, select a.*,b.description from (select min(item),sum(quantity),sum(amount),sum(gross),sum(net),sum(meas),min(invoice_id) from details goup by FLOOR(item)) a left join details b on a.item=b.item order by item
select a.*,b.description from (select min(item) as item ,sum(quantity) as quantity ,sum(amount) as amount ,sum(gross) as gross ,sum(net) as net ,sum(meas) as meas ,min(invoice_id) as invoice_id from details goup by FLOOR(item)) a left join details b on a.item=b.item order by a.item
select a.*,b.description from (select min(item),sum(quantity),sum(amount),sum(gross),sum(net),sum(meas),min(invoice_id) from details
goup by FLOOR(item)) a left join details b on a.item=b.item order by item
select a.*,b.description from (select min(item) as item ,sum(quantity) as quantity ,sum(amount) as amount ,sum(gross) as gross ,sum(net) as net ,sum(meas) as meas ,min(invoice_id) as invoice_id from details
goup by FLOOR(item)) a left join details b on a.item=b.item order by a.item