SQL Query to Find Nth Highest Salary Using Dense Rank Function

What if there's a duplicate salary?

Thank you mam

Excellent explanation.... Thanks

Sukriyaa mam. You solved my big question❤️❤️

If we have duplicates ...
Then how can we write query...?

Mam please use the max function instead of dense rank

Mam please use max function

Saadia appi you are great ❤️❤️❤️

Define a variable with Varchar 1000 and assign
the value ‘IND-India,JPN-Japan,US-United States’
This string can be of any length.
Write a dynamic query to insert data in a table with
two columns column 1 should have Country Short
Form and column 2 should have Country Full Form.
Output should be: -
Short Form Full Form
IND India
JPN Japan
US United States

Ma'am Please solve this question with explanation

Does rank function gives the same result?

Do you have any suggestion for SQL course to be taken for beginners/intermediate/advanced level?

This can be said another way of finding second highest salary, video having 3 methods : max,limit,top right ?

Why did you use "in line" sub query

Ma'am you didn't give the definition or working of (DENSE_rank). Please elaborate it.