sql - 表未加入的 SQL Oracle 加入问题

Question

我认为问题是我在某个地方加入了我的 OrderID 不在一起

我不知道如何解决它

select l.orderid, sum(l.qty) as units_sold, sum (l.qty) * p.price as Sales_Amount
from order_lines l join
     products p
     on p.prodid = l.prodid
group by l.orderid, p.price
Order by sum(l.qty) * p.price 

有点像输出。231 未加入

OrderID.          Units sold.       Price
231.                       5.                   5
243.                        6.                   6
246.                        7.                   7
231.                        8.                    8
247.                        6.                     9

标签： sqloracle

Answer 1

我怀疑您实际上想要：

select l.orderid, sum(l.qty) as units_sold, sum(l.qty * p.price) as Sales_Amount
from order_lines l join
     products p
     on p.prodid = l.prodid
group by l.orderid
Order by Sales_Amount ;

该group by子句指定您希望如何定义结果集中的行。如果你只想要每行orderid，那么你应该只orderid在group by.