sql 根据表字段去重

select * from (
select ROW_NUMBER() over (partition by patientid order by physicaltime desc) rownum
,* 
from TJDAGL_PhysicalUser
) as t where rownum=1

当表TJDAGL_PhysicalUser中需要按照字段patientid去重时，可以使用关键字【partition by】，partition by 后面接去重的字段，order by 按一定字段排序，然后取第一条记录，即可达到去重效果。