我试了:SELECT (distinct attid),userid, lasttime FROM tb1 ORDER BY lasttime DESC 不对,提示: #1064 - You have an error in your SQL syntax near DISTINCT attid ORDER BY lasttime DESC LIM' at line 1
楼主的意思就是查询每组中最大的lasttime,不如这样 select attid,userid,max(lasttime) from tb1 group by attid order by lasttime descending
select attid,userid,max(lasttime) from tb1 group by attid order by lasttime descending
不对,提示:
#1064 - You have an error in your SQL syntax near DISTINCT attid
ORDER BY lasttime DESC LIM' at line 1
select attid,userid,max(lasttime) from tb1 group by attid order by lasttime descending