Hvernig á að birta RowNumber með Select Fyrirspurn í SQL Server 2005

rownumber() function is used to return the rownumber with select query

The Follwoing query will return the result set row number

Setningafræði
ROW_NUMBER ( ) OVER ( [ ] )

Dæmi
Select row_number() over(order by productid) as SlNo,productname,unitprice from products