In this video I have shared one of the most important and frequently asked question in interview :-
Find nth highest salary in SQL with the below methods
1- With the help of Window Function
2- Without window Function with the help of CTE
3- Without window Function with the help of SUBQUERY
4- With the help of offset