先分組后分配 mysql先排序后分組？
mysql先排序后分組？用分組函數(shù)來(lái)做，假如你的表名是table_nameselect A.*from table_name A，(select product，max(date) max_date
mysql先排序后分組？
用分組函數(shù)來(lái)做，假如你的表名是table_nameselect A.*from table_name A，(select product，max(date) max_date from table_name group by product) Bwhere A.product=B.product and A.date=B.max_date