Slik viser ROWNUMBER med Select spørring i SQL Server 2005

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

The Follwoing query will return the result set row number

Syntax
ROW_NUMBER ( ) OVER ( [ ] )

Eksempel
Select row_number() over(order by productid) as SlNo,productname,unitprice from products