mysql 筛选出唯一值并排序
SELECT 版本,max(id) id FROM 表 GROUP BY 版本 order by id desc
SELECT maName,max(maDf) maDf,max(maYs) maYs FROM phb GROUP BY maName order by maDf desc, maYs ASC limit 0,450
感谢!!!!!!!
一个爱自由的PHP程序员
SELECT 版本,max(id) id FROM 表 GROUP BY 版本 order by id desc
SELECT maName,max(maDf) maDf,max(maYs) maYs FROM phb GROUP BY maName order by maDf desc, maYs ASC limit 0,450
感谢!!!!!!!