SELECT *,max(time) as max_time FROM t_table_1 where time>'1285862400' and time<'1293724800' group by name HAVING time=max_time order by max_time desc
group by 先分组,去重,然后时间,或者等级,或者名字排序,头疼啊
...全文
1566打赏收藏
group by 分组后,再排序,是个头疼的问题
SELECT *,max(time) as max_time FROM t_table_1 where time>'1285862400' and time<'1293724800' group by name HAVING time=max_time order by max_time desc group by 先分组,去重,然后时间,或者等级,或者名字排序,头疼啊
SELECT * FROM (SELECT * FROM t_table_1 where create_time>'1285862400' and create_time<'1293724800' ORDER BY record_time DESC,create_time desc) AS NEW where create_time>'1285862400' and create_time<'1293724800' GROUP BY name order by record_time desc,create_time desc limit 0,10