分组的字段为timestamp,qid,hid,排序的字段为time_use,desc表示降序,临时表的限制条件是scene为4或者5,日期为20180702,time_use小于180000
sql语句为'select *,max(time_use) from (select * from origin_data where (scene=5 or scene=4) and date="20180702" and time_use<180000 order by time_use desc ) as a group by timestamp,qid,hid;'
由于group by有去重的作用,这样就得到每个分组的最大time_use的那一行了!