SQL Query | How to find employees with highest salary in a department

Рет қаралды 47,852

3 жыл бұрын

This video is part of the series of videos on SQL Queries on Employee Salary database
How to find employees with maximum salary in a department
Check out all the SQL Queries and KZfaq videos for this series here -
know-star.blogspot.com/2021/0...
How to install SQL Server for practice?
• How to install SQL Ser...
Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
imp.i384100.net/qnXYk5
Data Science Fundamentals with Python and SQL Specialization
imp.i384100.net/mgVYre
Python for Everybody Specialization
imp.i384100.net/DVz7Aj
Google Data Analytics Professional Certificate
imp.i384100.net/OR37oQ
Coursera Plus - Data Science Career Skills
imp.i384100.net/c/3299742/132...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.com/company/know...
Email - learn@knowstar.org

Пікірлер: 41

@rapo107 3 жыл бұрын

No words to explain how valuable this video... Take a bow ma'am..🙏🙏🙏

@LearnatKnowstar 3 жыл бұрын

Thanks so much!

@kishorkumar007 3 жыл бұрын

Thxs for sharing this. I always stuck in this scenario question. This video will help

@LearnatKnowstar 3 жыл бұрын

Glad it was helpful!

@f4tm4_f4t4l3 2 жыл бұрын

thank you soooo much for the second solution. i looked at so many solutions but they were all in postgrSQL or mySQL and didnt work with tSQL ... finally i can rest in peace

@LearnatKnowstar 2 жыл бұрын

Thank you so much

@alwaysbehappy1337 3 жыл бұрын

Thanks a lot...👍👍👍

@LearnatKnowstar 3 жыл бұрын

Thank you

@srat859 2 жыл бұрын

Nice and great explanation more to come as videos. It helps a lot people like me

@LearnatKnowstar 2 жыл бұрын

Glad it helped

@pavanyeluri8728 2 жыл бұрын

Can we use correlated sub query using each where clause with dept as the joining condition?

@marcocruz5351 3 жыл бұрын

Can i please see the ERD table of this example? thanks!

@dimpyrathore818 3 жыл бұрын

Very helpful

@LearnatKnowstar 3 жыл бұрын

Thank you

@hv0032113 3 жыл бұрын

Great tutorial

@LearnatKnowstar 3 жыл бұрын

Thank you

@selvan8000 3 жыл бұрын

Nice video and helpful

@LearnatKnowstar 3 жыл бұрын

Thanks so much!!

@S17051985 2 жыл бұрын

Mam, how to find out number of transactions including current and historical transactions for an id if records are maintained in different database??

@ariumboroseno 2 жыл бұрын

It is a great video, but it would be nice if you put .sql file in description so we can practice with same example 😁😁 just advice

@LearnatKnowstar 2 жыл бұрын

Thank you. Sure, we will try to add the sql files for upcoming videos👍

@jirkablaha1562 Жыл бұрын

@@LearnatKnowstarCould you please put the URL to that test database? I tried several but none were right.

@BnfHunterr Жыл бұрын

can we do this with cte

@RK-wf7re Жыл бұрын

Can't we use subquery to derive these outputs??

@TheVaibhavdang Жыл бұрын

Nice video. Kindly share the same data aswell .That would be really helpful

@LearnatKnowstar Жыл бұрын

The same query is covered in our latest tutorial on complex queries kzfaq.info/get/bejne/e8Vmm8R2xJeUlXk.html There is practice data available for that tutorial. Hope it helps!

@TheVaibhavdang Жыл бұрын

@@LearnatKnowstar Thank you so much. In real time scenerio of HR database,I used cte to make a temp table joing employees and departments table to practice your question.😀😀 Thank you so much for the dataset.It will save some time.

@sibilyantv401 3 жыл бұрын

Display the 35 years old and above with the highest salary ., pls help me

@rajeshbathula5505 2 жыл бұрын

Ma'am, How to find the difference between punch in & punch out times of each employee, if those values are not in the same record?

@LearnatKnowstar 2 жыл бұрын

You can try to do a self join to fetch the two related records.

@rajeshbathula5505 2 жыл бұрын

@@LearnatKnowstar Thank you...

@ukkashs444 Жыл бұрын

How to get max salary as well as min salary on department wise with employee other details as well.

@LearnatKnowstar Жыл бұрын

You can use windows function - rank as explained in the second approach in the video. Max Sal = Rank = 1 Order sal desc Min Sal = Rank = 1 Order Sal Asc

@hafizqasimxprt855 3 жыл бұрын

show the ERD table

@arshadpathan8040 2 жыл бұрын

Query : list the name of the employee and department having salary >50000

@RajaSekhar-qs2lz Жыл бұрын

Find out top 2 salaries from each department and list them out: Table1 ====== DEPT id dept_name Table2 ========== EMP emp_id dept_id # foreign_key salary