SQL分组且取每组某个字段最大或最小值

 

有个表gz：

要按sku分组，同时取每个sku的stock最大的那条

SQL语句:

SELECT * FROM (SELECT * FROM gz ORDER BY  stock DESC ) a GROUP BY sku 

结果：

如果要最小的那条，

SELECT * FROM (SELECT * FROM gz ORDER BY  stock ASC) a GROUP BY sku 

结果：

 

其实下面的更简单：

 SELECT sku, MAX(stock) FROM gz GROUP BY sku