sql相同数据去掉，取时间最近的一条

SELECT * FROM dis_deliveryman_report WHERE ddid in

(SELECT t.ddid FROM (SELECT ddid=MAX(ddid),createtime=MAX(createtime) FROM dbo.dis_deliveryman_report

GROUP BY usid) as t)

convert(varchar(10),createtime,120)=getdate()

值：yyyy-MM-dd

convert(varchar(20),createtime,120)=getdate()

值：yyyy-MM-dd HH:mm:ss

作者 yaerfeng