Tsql row number

This article is tagged with: Tsql row number and mysql

tsql row number

SELECT
   ROW_NUMBER() OVER (
ORDER BY first_name
   ) row_num,
   first_name,
   last_name,
   city
FROM
   sales.customers;

how to use row number function in sql server

USE AdventureWorks2012;
GO
WITH OrderedOrders AS
(
SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (ORDER BY OrderDate) AS RowNumber
FROM Sales.SalesOrderHeader
)
SELECT SalesOrderID, OrderDate, RowNumber
FROM OrderedOrders
WHERE RowNumber BETWEEN 50 AND 60;

This article is tagged with: Tsql row number and mysql