SqlServer去重

/*
SerialNum  序号
FindTable  临时表
*/
 SELECT  * FROM
(SELECT ROW_NUMBER() OVER (PARTITION BY 字段1+字段2 ORDER BY 字段1+字段2) SerialNum, 主键,字段1,字段2,....
FROM 去重表名称) as FindTable WHERE FindTable.SerialNum=1  ORDER BY 字段2 

--例如
 SELECT  * FROM
(SELECT ROW_NUMBER() OVER (PARTITION BY RecordId+OriFileName ORDER BY RecordId+OriFileName) SerialNum, id,RecordId,OriFileName
FROM t_jh_attach) as findtable WHERE findtable.SerialNum=1  ORDER BY RecordId