Using dynamic index number with Select Queries

To include index numbers in select query SQL Server provides “Row_Number()” and “rank()” methods. Following is the example to use the methods.

Example

SELECT Row_Number() OVER (ORDER BY ORD.OrderDesc) as LIST_ORDER ,ORD.OrderDesc
FROM tblOrderDescaster ORD