Perform Dense Rank on SQL Query.

Perform Dense Rank on SQL Query.

1|cse|3000

2|ece|2000

3|ece|1000

4|cse|3000

5|ece|4000

6|cse|4000

SELECT *,dense_rank()over(partition by dept order by salary) FROM students;

1|cse|3000|1

4|cse|3000|1

6|cse|4000|2

3|ece|1000|1

2|ece|2000|2

5|ece|4000|3