一個table(Order)如下數據 ID item price
0001 0 1000
0001 0 1450
0001 1 150
0003 0 1800
0013 0 4050
如何通過一條sql語句得出如下結果
ID item price
0001 0 2450
0001 1 150
0003 0 1800
0013 0 4050
0001 0 1000
0001 0 1450
0001 1 150
0003 0 1800
0013 0 4050
如何通過一條sql語句得出如下結果
ID item price
0001 0 2450
0001 1 150
0003 0 1800
0013 0 4050
select ID,item,sum(price) as price from Order group by ID,item
select ID,item,sum(price) as price from Order group by ID,item
select 0001,0,1000 union
select 0001,0,1450 union
select 0001,1,150 union
select 0003,0,1800 union
select 0013,0,4050 select id,item,sum(price) as price from csdn group by id,itemselect * from dbo.csdnid item price
----------- ----------- -----------
1 0 2450
3 0 1800
13 0 4050
1 1 150(4 行受影响)id item price
----------- ----------- -----------
1 0 1000
1 0 1450
1 1 150
3 0 1800
13 0 4050(5 行受影响)
select ID,item,sum(price) as price from Order group by ID
price=perPrice * quantity
那麼你們的寫法還成立麼?