on date datetime
12 2008-09-01 09:45
23 2008-09-01 11:45
13 2008-09-01 13:45select on,date,datetime from OBBT
ORDER BY date,datetime DESC 这样也排充有错吗,需求是,要date时间是最大的,相同的date时,再去取datetime里最大的值.
即最后的结果要是
on date datetime
13 2008-09-01 13:45
23 2008-09-01 11:45
12 2008-09-01 09:45
12 2008-09-01 09:45
23 2008-09-01 11:45
13 2008-09-01 13:45select on,date,datetime from OBBT
ORDER BY date,datetime DESC 这样也排充有错吗,需求是,要date时间是最大的,相同的date时,再去取datetime里最大的值.
即最后的结果要是
on date datetime
13 2008-09-01 13:45
23 2008-09-01 11:45
12 2008-09-01 09:45
ORDER BY date desc,datetime DESC