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

[@leishasharma4195]

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

[@lotusamaze1142]

You are welcome!

[@saniyaofficial2565]

Thank U Sir🎉❤

[@lotusamaze1142]

Thanks

[@karanmalkhede6689]

Great

[@lotusamaze1142]

Thanks

[@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

[@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

[@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

[@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

[@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*/