How to find nth highest salary in sql in hindi | Find nth highest salary in sql in hindi

How to find nth highest salary in sql in hindi | Find nth highest salary in sql in hindi
How to find nth highest salary in sql in Hindi help you to learn different approaches for finding nth highest salary in sql.
Different approaches are max function, sub query, corelated sub query, dense rank function, cte, common type expression
MS SQL Hindi Playlist : • SQL Tutorials-Hindi
MS SQL English Playlist : • SQL Tutorial-English
Power BI DAX Hindi Playlist : • DAX Hindi
Power BI DAX English Playlist : • DAX English
Power BI Hindi Playlist : • Power BI Tutorials-Hindi
Power BI English Playlist : • Power BI Tutorials-Eng...
#sqlserver #sql #sqlinterviewquestions #mssqlserver #sqlforbeginners #education #rdbms #sqlcourse #sqlcommands

[@saniyaofficial2565]

Thank U Sir🎉❤

[@leishasharma4195]

Good explanation. This is very well clear now.. Thank you

[@lotusamaze1142]

You are welcome!

[@mohammadfaisalirani3899]

Dear Sir
Thanks for your tutorial.
I tried cte with dense rank function.
It gives result of ctresult.
But didn't get from
Select top 1 id, salary from ctresult where salaryrank,=1,
Would you please help me.
Mohammad Faisal Irani
Dhaka Bangladesh

[@lotusamaze1142]

Send me full code

[@nazirmsa6874]

Good explaination ! But if i want to find second highest salary but same salary of two employee then how ?

[@lotusamaze1142]

it will take first occurrence salary

[@nazirmsa6874]

@@lotusamaze1142 could you please share query

[@ankurmishra3042]

Sir is there any way i can take a course of SQL from you

[@lotusamaze1142]

We provide training on sql contact on WA 91-8076787743

[@ishukumar]

Thank you so much brother, you really explained very clearly

[@lotusamaze1142]

Glad it helped

[@faizraina6]

how to handle null occurance in this question. Leetcode question 176

[@lotusamaze1142]

Replace Null value with 0(Zero) Use ISNULL function

[@karanmalkhede6689]

Great

[@lotusamaze1142]

Thanks

[@pbbhosale9]

Sir ROWNUM se kaise highest salary nikale?

[@lotusamaze1142]

SELECT * FROM (
SELECT *, row_number() OVER (order by salary desc) AS MyRowNumber FROM Employee
) recordSet
WHERE MyRowNumber =N; /*N is the nth highest salary*/