USE OLAP
--Rank versus Dense Rank: A deeper dive
SELECT top 6 product,product_cost
       ,RANK() OVER (order by product_cost) as rank --Ranking based on price
	   ,DENSE_RANK() OVER (order by product_cost) as dense_rank --Dense Ranking based on price
FROM products
ORDER BY product_cost --order based on price