sqlserver 去重，取最大值

select * from(select ROW_NUMBER() over (partition by u.prjviewid order by u.CreateTime desc) numm,*
 from tbl_option_bd_newzjfx u where u.prjviewid in (
select t.Id from TBL_ITEM t where t.SPAREFIELD15=1 and t.Id in(select a.Id from TBL_ITEM a
where a.SPAREFIELD20 in ('固原'))) and  u.DATA1 like'%决算%'and u.DATA2 like'%静态投资%'
) a where a.numm=1