No video
SQL Query for Nth Highest Salary In Each Department Using Dense Rank Function
Рет қаралды 14,666
Күн бұрынHi, In this video we've discussed the query to find nth highest salary in each department in SQL. This is an important SQL query to master for SQL Interviews
✨Work related mails can be sent on work.sadiasiddiqui@gmail.com
✨If you appreciate my work and would like to donate to support our channel, you can do so here : paypal.me/sadi...
✨Please like, share, subscribe and comment down. It would make my day :)
Thank you, have a nice day!
@pulkitsrivastava4211 2 жыл бұрын
Loud and clear thanks you so much try to cover some more complex queries
@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
@gudguy1a Ай бұрын
Good job - I also 'preciate it - informative explanation.
@avinashsathe2322 Ай бұрын
Thank you mam great explained
@santanupuhan1259 9 ай бұрын
Thank you for such clarity
@amanshukla1126 Жыл бұрын
hey it's really well explained ,thanks.
@anubhaverma5802 3 ай бұрын
if two employees have same salary, then doing distinct salary will affect the output? or what will be the output in tht scennrio
@omkaraj1 Жыл бұрын
Hi, thanks for d share, can we query only rows and columns with NULLs with full or incomplete data from a table ..
@pavangsk8404 Жыл бұрын
hi maam , i have one queston for which im not able to solve can you explain that pls its is related to this...
@NepaliQuanta Жыл бұрын
someone pls explain me what is the role of d in the table..
@jaitiwari241 2 жыл бұрын
How I get dataset for this table ro practice
@vikasvicky1158 Жыл бұрын
How Can we write rank() in joins concept
@muddarlasreelakshmi2276 2 жыл бұрын
Hi u published any SQL and etl testing notes
Questpond
Рет қаралды 48 М.
CodeEra
Рет қаралды 104 М.
Crack Concepts
Рет қаралды 17 М.
Learn at Knowstar
Рет қаралды 48 М.
Write a SQL Query to find Max salary of each Department with department name. #sqlinterviewquestions
The Data Millennials
Рет қаралды 11 М.