Breaking News: Grepper is joining You.com. Read the official announcement!

row number order by

Ram S answered on June 9, 2023 Popularity 2/10 Helpfulness 3/10

answer row number order by

related row number order by

row number order by

Comment

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;

Popularity 2/10 Helpfulness 3/10 Language whatever

Source: learn.microsoft.com

Tags: row-number whatever

Link to this answer
Share Copy Link

Contributed on Jun 09 2023

Ram S

0 Answers Avg Quality 2/10

Closely Related Answers

row number order by

Comment

SELECT 
  ROW_NUMBER() OVER(ORDER BY name ASC) AS Row#,
  name, recovery_model_desc
FROM sys.databases 
WHERE database_id < 5;

Popularity 2/10 Helpfulness 1/10 Language whatever

Source: learn.microsoft.com

Tags: row-number whatever

Link to this answer
Share Copy Link

Contributed on Jun 09 2023

Ram S

0 Answers Avg Quality 2/10

row number order by

Comment

USE AdventureWorks2012;  
GO  
SELECT FirstName, LastName, TerritoryName, ROUND(SalesYTD,2,1) AS SalesYTD,  
ROW_NUMBER() OVER(PARTITION BY TerritoryName ORDER BY SalesYTD DESC) 
  AS Row  
FROM Sales.vSalesPerson  
WHERE TerritoryName IS NOT NULL AND SalesYTD <> 0  
ORDER BY TerritoryName;

Popularity 2/10 Helpfulness 1/10 Language whatever

Source: learn.microsoft.com

Tags: whatever row-number

Link to this answer
Share Copy Link

Contributed on Jun 09 2023

Ram S

0 Answers Avg Quality 2/10

row number order by

Contents

More Related Answers

row number order by

Closely Related Answers

row number order by

row number order by

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.