完整的sql应该是这样的，对于CREATEDATE 进行降序排序select * from USER order by CREATEDATE ASC如果之要查询最近的那个日期的所有记录，sql语句如下：select * from user inner join (select max(CREATEDATE) as C from user) A on user.CREATEDATE=A.C;
