2010-6-30 小日本出局，赞，阳光明媚

取得一张表内 相同ID，不同时间的最大时间列

select id, MAX (date) as date from
(
select 1 as id , ' 2010-06-30 ' as date
union select 1 as id, ' 2010-06-29 ' as date
) as temp group by id

 

 

 

转载于:https://www.cnblogs.com/tigersong/archive/2010/06/30/1768215.html