查詢結果帶行号的t-sql語句,可用于sql語句分頁

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