这是我的sql查询,我只想从销售表中按降序排列sellingPrice需要帮助提前谢谢。
例如
SELECT salesMan.salesmanID, salesMan.name, SUM(sale.sellingPrice)
FROM salesMan
INNER JOIN sale ON salesMan.salesmanID = sale.salesManID
GROUP BY salesmanID, name;
然后添加:
order by SUM(sale.sellingPrice) desc
这应该有效:
Select salesMan.salesmanID, salesMan.name, SUM(sale.sellingPrice) AS totalSale
FROM salesMan INNER JOIN
sale
ON salesMan.salesmanID = sale.salesManID
GROUP BY salesmanID, name
ORDER BY totalSale DESC;
您可以这样简化查询:
SELECT sm.salesmanID, sm.name, SUM(s.sellingPrice) AS totalSale
FROM salesMan sm
INNER JOIN sale s ON sm.salesmanID = s.salesManID
GROUP BY sm.salesmanID, sm.name
ORDER BY totalSale DESC;
将别名添加到SUM
列,并使用它对结果集进行排序。
Select salesMan.salesmanID,salesMan.name, SUM(sale.sellingPrice) as sellingPriceSum
FROM salesMan INNER JOIN
sale
ON salesMan.salesmanID = sale.salesManID
GROUP BY salesmanID,name
ORDER BY sellingPriceSum desc;