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

[@rapo107]

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

[@LearnatKnowstar]

Thanks so much!

[@ariumboroseno]

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]

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.

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

[@BnfHunterr]

can we do this with cte

[@srat859]

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

[@LearnatKnowstar]

Glad it helped

[@kishorkumar007]

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

[@LearnatKnowstar]

Glad it was helpful!

[@selvan8000]

Nice video and helpful

[@LearnatKnowstar]

Thanks so much!!

[@alwaysbehappy1337]

Thanks a lot...👍👍👍

[@LearnatKnowstar]

Thank you

[@pavanyeluri8728]

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

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

[@arshadpathan8040]

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

[@Beyondhorizons-i5z]

Very helpful

[@LearnatKnowstar]

Thank you

[@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 kzbin.info/www/bejne/e5CZmZR7lJZjm6c 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.

[@S17051985]

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

[@RK-wf7re]

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

[@Sanath427]

Hi in place of maxsal=1 I want max salary value for all records is it possible let me know

[@MrRagerrrr7777]

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

[@hv0032113]

Great tutorial

[@LearnatKnowstar]

Thank you

[@sibilyantv401]

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

[@rajeshbathula5505]

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]

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

[@rajeshbathula5505]

@@LearnatKnowstar Thank you...

[@jaitiwari241]

Maam where is sql script

[@LearnatKnowstar]

You can find it here - know-star.blogspot.com/2021/01/sql-interview-queries-on-employee.html?m=1

[@hafizqasimxprt855]

show the ERD table

[@Abhinavkumar-og3xd]

Please speak in hindi.

[@surajpatil3579]

Very helpful

[@LearnatKnowstar]

Glad to hear that