有如下示例数据：订单明细表：test_order_item id order_id goods_id price 1 11701245001 1001 10 2 11701245001 1002 20 3 11701245002 1001 10 问题：用SQL 查询计算出每个订单的总金额，并按照订单号进行降序排列：订单号和订单总金额.

多选题

有如下示例数据：
订单明细表：test_order_item

id order_id goods_id price
1 11701245001 1001 10
2 11701245001 1002 20
3 11701245002 1001 10

问题：
用SQL 查询计算出每个订单的总金额，并按照订单号进行降序排列：订单号和订单总金额.

SELECT i.order_id, SUM(i.price) FROM test_order_item i group by i.`order_id` order by i.order_id desc;

SELECT order_id, price FROM test_order_item group by order_id and sum(price) order by order_id desc;

SELECT order_id, SUM(price) FROM test_order_item group by order_id order by order_id desc;

SELECT order_id, SUM(price) FROM test_order_item group by order_id order by order_id ASC;

确定

上一题

下一题

题目信息

校招真题

正确率

点击

我的笔记