N_CART_ID :ID
N_PRICE :单价
N_AMOUNT :数量语句1:SELECT SUM(N_PRICE*N_AMOUNT) FROM INFO_SHOPPING_CART_TAB语句2:SELECT N_CART_ID,SUM(N_PRICE*N_AMOUNT) FROM INFO_SHOPPING_CART_TAB group by N_CART_ID如果用语句2这样去写SUM(N_PRICE*N_AMOUNT)
里的SUM就没用了。如果要达到语句1的效果还要循环下数据加一下?
N_PRICE :单价
N_AMOUNT :数量语句1:SELECT SUM(N_PRICE*N_AMOUNT) FROM INFO_SHOPPING_CART_TAB语句2:SELECT N_CART_ID,SUM(N_PRICE*N_AMOUNT) FROM INFO_SHOPPING_CART_TAB group by N_CART_ID如果用语句2这样去写SUM(N_PRICE*N_AMOUNT)
里的SUM就没用了。如果要达到语句1的效果还要循环下数据加一下?
SELECT '44' AS N_CART_ID,'6999' AS N_PRICEN_AMOUNT FROM DUAL
UNION ALL
SELECT '61' AS N_CART_ID,'4500' AS N_PRICEN_AMOUNT FROM DUAL
UNION ALL
SELECT '62' AS N_CART_ID,'24600' AS N_PRICEN_AMOUNT FROM DUAL
UNION ALL
SELECT '63' AS N_CART_ID,'14498' AS N_PRICEN_AMOUNT FROM DUAL
UNION ALL
SELECT '65' AS N_CART_ID,'26400' AS N_PRICEN_AMOUNT FROM DUAL
UNION ALL
SELECT '81' AS N_CART_ID,'796' AS N_PRICEN_AMOUNT FROM DUAL
)
select N_CART_ID,SUM(N_PRICEN_AMOUNT)OVER() AS N_PRICEN_AMOUNT FROM TEST这个效果?
感觉不是很清楚你要什么,你看看我写的这个吧
SELECT DECODE(GROUPING(n_cart_id), 1, 'All value',
n_cart_id) AS n_cart_id,
SUM(n_price*n_amount)
FROM info_shopping_cart_tab
GROUP BY ROLLUP (n_cart_id);
SELECT SUM(AMOUNT) FROM
(SELECT N_CART_ID,SUM(N_PRICE*N_AMOUNT) AMOUNT FROM INFO_SHOPPING_CART_TAB group by N_CART_ID)
用我的语句1 只有总钱数 没有 其他列的书数据
语句2 有其他列的数据 但是没有总钱数 只查询 N_CART_ID,SUM(N_PRICE*N_AMOUNT) 这些用你说的可以
如果查询 n_price,n_amount,N_CART_ID,SUM(N_PRICE*N_AMOUNT) 在加上两列 语句应该怎样写
SELECT a.n_cart_id,a.gross,b.gross FROM
(SELECT n_cart_id,SUM(n_price*n_amount) gross
FROM info_shopping_cart_tab
GROUP BY n_cart_id) a,(SELECT SUM(n_price*n_amount) gross
FROM info_shopping_cart_tab) b这个行伐?
union all
select '求和' , sum(d.num1*d.num2) from test1 d;
SELECT N_CART_ID,SUM(N_PRICE*N_AMOUNT) FROM INFO_SHOPPING_CART_TAB group by N_CART_ID
union all
SELECT '求和', SUM(N_PRICE*N_AMOUNT) FROM INFO_SHOPPING_CART_TAB
我的那条语句不能实现吗?
SELECT a.n_cart_id,a.gross,b.gross FROM
(SELECT n_cart_id,SUM(n_price*n_amount) gross
FROM info_shopping_cart_tab
GROUP BY n_cart_id) a,
(SELECT SUM(n_price*n_amount) gross
FROM info_shopping_cart_tab) b
SELECT cart_id
,price
,amount
,SUM(price*amount) over()
FROM temp