How to find nth highest salary in sql in hindi | Find nth highest salary in sql in hindi
Вставка
- Опубліковано 7 вер 2024
- 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
Good explanation. This is very well clear now.. Thank you
You are welcome!
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
Send me full code
how to handle null occurance in this question. Leetcode question 176
Replace Null value with 0(Zero) Use ISNULL function
Thank you so much brother, you really explained very clearly
Glad it helped
Great
Thanks
Good explaination ! But if i want to find second highest salary but same salary of two employee then how ?
it will take first occurrence salary
@@lotusamaze1142 could you please share query
Sir is there any way i can take a course of SQL from you
We provide training on sql contact on WA 91-8076787743
Sir ROWNUM se kaise highest salary nikale?
SELECT * FROM (
SELECT *, row_number() OVER (order by salary desc) AS MyRowNumber FROM Employee
) recordSet
WHERE MyRowNumber =N; /*N is the nth highest salary*/