select row_number() over(order by tabTemp.staffId desc) rn row_number()orver(order by ***)根据***进行排序,数据不重复.