nina_88 发表于 2007-8-17 11:34
急！请教一个select问题，谢谢大家了
<P>表A 字段 中有 订单类型PART_ORDER_TYPE，订单金额PART_ORDER_AMOUNT<BR> 根据PART_ORDER_TYPE（有4种类型）分别计算出各种类型对应PART_ORDER_AMOUNT的和，以及每种类型PART_ORDER_AMOUNT和占总订单金额的百分比<BR>请问种如何写SELECT，谢谢</P>
sky_yang_sky 发表于 2007-9-5 13:30
declare @tb table(type varchar(2),cout numeric(18,4))<BR>insert @tb <BR>select 1,200<BR>union all<BR>select 2,300<BR>union all <BR>select 3,400<BR>select * from @tb<BR>declare @tb2 table(type varchar(2),cout numeric(18,4),pe numeric(18,4))<BR>--select sum(cout) from @tb<BR>declare @n numeric(18,4)<BR>select @n=sum(cout) from @TB-- group by cout<BR>select @n<BR>insert into @tb2<BR>select type as type,[cout] as cout,[cout]/@n as pe from @tb<BR>select * from @tb2<BR><BR>根據自己的要求改動
ILoveMK 发表于 2007-9-13 23:17
<P>select sum(outer.PART_ORDER_AMOUNT) sum_part,(<BR> select outer.sum_part/sum(inner.PART_ORDER_AMOUNT<BR> ) sum_total from A inner<BR> ) from A outer<BR> group by outer.PART_ORDER_TYPE</P>
页:
[1]
