嘗試運行一個查詢，該查詢應該從另一個表中回傳所有機制和所有傭金的總和，但只獲取一個機制名稱和所有傭金的總和。嘗試以不同的方式撰寫查詢，但得到相同的結果。
查詢：
SELECT DISTINCT m.mechID, fname || ' ' || lname AS 'Full Name', SUM(commission) AS 'Total Commissions Per Mechanic'
FROM
mechanics AS m
INNER JOIN mech_commissions AS mc on m.mechID = mc.mechID
ORDER BY "Full Name";
輸出：
uj5u.com熱心網友回復：
我想你想要一個聚合查詢：
SELECT m.mechID, m.fname || ' ' || m.lname AS `Full Name`,
SUM(mc.commission) AS `Total Commissions Per Mechanic`
FROM mechanics AS m
INNER JOIN mech_commissions AS mc ON m.mechID = mc.mechID
GROUP BY 1, 2
ORDER BY `Full Name`;
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/448512.html
標籤：sqlite