本文此处所规定的类别为省份ID,原始表如下图所示:
所使用SQL语句为:
select a.* from tbl_MaterialPice a,(select province_ID,max(price_time) price_time from tbl_MaterialPice group by province_ID) b
where a.price_time = b.price_time and a.province_ID = b.province_ID and material_ID='1' order by a.province_ID
最终结果如下图所示;