程式設計@筆記

SELECT GREATEST(15,10,25); 取最大值
輸出：25

SELECT LEAST(15,10,25); 取最小值
輸出：10

 

若使用group by 則用min() max()

例1
SELECT working_area, MIN(commission)
FROM agents
GROUP BY working_area;

例2
SELECT working_area, max(commission)
FROM agents
GROUP BY working_area;