sql 查询出当天记录数据

   
select updatetime,NewComment,HistoryID,sum(1) over(partition by UpdateTime)
from LPProjectHistory
order by updatetime desc