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

dense_rank vs row_number

ashattack answered on November 9, 2020 Popularity 9/10 Helpfulness 1/10

answer dense_rank vs row_number

dense_rank vs row_number

Comment

-1

WITH T(StyleID, ID)
     AS (SELECT 1,1 UNION ALL
         SELECT 1,1 UNION ALL
         SELECT 1,1 UNION ALL
         SELECT 1,2)
SELECT *,
       RANK() OVER(PARTITION BY StyleID ORDER BY ID)       AS 'RANK',
       ROW_NUMBER() OVER(PARTITION BY StyleID ORDER BY ID) AS 'ROW_NUMBER',
       DENSE_RANK() OVER(PARTITION BY StyleID ORDER BY ID) AS 'DENSE_RANK'
FROM   T

Popularity 9/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: whatever

Link to this answer
Share Copy Link