sqlserver查询重复的数据

select RecID from
(
select *, Orderno=ROW_NUMBER() over(Partition by UserID,HosSecID, FromID,RecData1,RecData2,RecData3,RecData4,RecData5,RecData6,Recdata7 order by RecDate desc)
from Rec_CaseClass
)temp
where Orderno>1