Advanced Search

Return to Snippet

Revision: 70444
at February 16, 2016 14:08 by ManuelToledo
Initial Code 
USE [AdventureWorks2016CTP3]

SELECT
	[Sales].[SalesOrderHeader].[CustomerID],
	count([SalesOrderID]) AS OrdersCount,
	DENSE_RANK() OVER (ORDER BY count([SalesOrderID]) DESC) AS Rank
	
FROM
	[Sales].[SalesOrderHeader]

GROUP BY 
	[Sales].[SalesOrderHeader].[CustomerID]
Initial URL 









Initial Description





SQL Server query sample using rank/dense_rank









Initial Title





SQL Server query sample using rank/dense_rank









Initial Tags





sql, server









Initial Language





SQL