SQL Interview Question | Use Different Methods to Find the Nth Highest Salary

[@chinmaymishra5086]

Instead of dense rank, we could use row number function, which helps better

[@skilltechath0n]

Great suggestion, using row_number() can also be a solution.

[@shripaddeshpande5766]

I think no, row number will give salary in 3rd row that may not be 3rd highest salary. Dense rank is correct.

[@sweetsubha514]

Nicely explained 😃👍👍👌👌👌👌👌

[@skilltechath0n]

Appreciate the support! Keep practicing your SQL skills.

[@Frelek321]

can u provide scripts for table and insert -> CHECK COMMENT

[@skilltechath0n]

@Frelek321 Thank you for the suggestion. I have added the query to create table and insert values in the description. I hope it helps. Keep practicing :)