查询结果带行号的t-sql语句,可用于sql语句分页

select row_number()over(order by score desc)as RowNum,* from SC where SC.Cid = 3 order by score desc