SELECT A.* FROM 表名 A, ( SELECT MAX(id) as id FROM 表名 WHERE 属性1= '属性1' GROUP BY 属性2字段名, 属性3字段名) B WHERE A.id= B.id ORDER BY A.属性1 DESC;
可根据MAX(),MIN()调试最大值或最小值
SELECT A.* FROM 表名 A, ( SELECT MAX(id) as id FROM 表名 WHERE 属性1= '属性1' GROUP BY 属性2字段名, 属性3字段名) B WHERE A.id= B.id ORDER BY A.属性1 DESC;
可根据MAX(),MIN()调试最大值或最小值