How to Perform RowNumber on SQL query

on

 How to Perform rank on SQL query

1|cse|3000

2|ece|2000

3|ece|1000

4|cse|3000

5|ece|4000

6|cse|4000


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

1|cse|3000|1

4|cse|3000|2

6|cse|4000|3

3|ece|1000|1

2|ece|2000|2

5|ece|4000|3

Comments

Post a Comment