SQL去重

当要查询的字段都是要去重的字段时则可以采用DISTINCT去重

select DISTINCT UID, Message 
from T_VOS 
where CreateDate >= '{0} 00:00:00' and CreateDate < '{1} 00:00:00

其它情况下采用以下方法去重

Select UID, Message ,Topic
From (Select *,ROW_NUMBER() OVER(Partition By UID Order By ID) 
as row From T_VOS) p 
Where p.row=1 AND DateDiff(dd, CreateDate, '2019-07-02') = 0