SQL Query for Nth Highest Salary In Each Department Using Dense Rank Function

[@pulkitsrivastava4211]

Loud and clear thanks you so much try to cover some more complex queries

[@gudguy1a]

Good job - I also 'preciate it - informative explanation.

[@rishabhsharma7259]

I'm looking for these query from last one week now I found the query of finding 2nd highest salary in each department, thank you so much, make more complex queries with explanation as well. Thank you

[@avinashsathe2322]

Thank you mam great explained

[@santanupuhan1259]

Thank you for such clarity

[@omkaraj1]

Hi, thanks for d share, can we query only rows and columns with NULLs with full or incomplete data from a table ..

[@amanshukla1126]

hey it's really well explained ,thanks.

[@anubhaverma5802]

if two employees have same salary, then doing distinct salary will affect the output? or what will be the output in tht scennrio

[@pavangsk8404]

hi maam , i have one queston for which im not able to solve can you explain that pls its is related to this...

[@jaitiwari241]

How I get dataset for this table ro practice

[@muddarlasreelakshmi2276]

Hi u published any SQL and etl testing notes

[@NepaliQuanta]

someone pls explain me what is the role of d in the table..

[@vikasvicky1158]

How Can we write rank() in joins concept