select userid,post,max(time) from post group by userid,post by time;
刚才把order落下了 select userid,post,max(time) from post group by userid,post order by time;
好像都不正确,会有重复的userid,而且group by的时候要加上time,
select A.userid,post,time from (select userid,min(post),time from post group by user_id,time order by time ) A where time = (select max(time) from post where userid=A.userid) 我觉的这样应该对吧!
Select userid,post,time From post where time=(select Max(time) from post) order by time
select userid,post,max(time) from post group by userid,post by time;
select userid,post,max(time) from post group by userid,post order by time;
我觉的这样应该对吧!
From post
where time=(select Max(time) from post)
order by time