急！请教一个select问题，谢谢大家了

nina_88 发布于 2007-08-17 11:34， 1867 次点击

表A 字段中有订单类型PART_ORDER_TYPE，订单金额PART_ORDER_AMOUNT
根据PART_ORDER_TYPE（有4种类型）分别计算出各种类型对应PART_ORDER_AMOUNT的和，以及每种类型PART_ORDER_AMOUNT和占总订单金额的百分比
请问种如何写SELECT，谢谢

2 回复

sky_yang_sky2007-09-05 13:30

declare @tb table(type varchar(2),cout numeric(18,4))
insert @tb
select 1,200
union all
select 2,300
union all
select 3,400
select * from @tb
declare @tb2 table(type varchar(2),cout numeric(18,4),pe numeric(18,4))
--select sum(cout) from @tb
declare @n numeric(18,4)
select @n=sum(cout) from @TB-- group by cout
select @n
insert into @tb2
select type as type,[cout] as cout,[cout]/@n as pe from @tb
select * from @tb2

根據自己的要求改動

ILoveMK2007-09-13 23:17

select sum(outer.PART_ORDER_AMOUNT) sum_part,(
select outer.sum_part/sum(inner.PART_ORDER_AMOUNT
) sum_total from A inner
) from A outer
group by outer.PART_ORDER_TYPE