【SQL进阶】子查询去重、获取商品分类最新销售情况

prod_sales 字段说明：

1、id  自增ID

2、prod_class 商品分类

3、sales_date 销售汇总日期

4、prod_id 商品ID或名称

5、sales_num 销售数量

select a.* from prod_sales a INNER JOIN
(select prod_class,max(sales_date) as sn from prod_sales
GROUP BY prod_class) b 
on a.prod_class=b.prod_class and a.sales_date=b.sn order by prod_class