Write a SQL Query to find Max salary of each Department with department name. #sqlinterviewquestions

Write a SQL Query to find Max salary of each Department with department name.

This is a trick question. There can be some departments without any employees. So we have to ask the interviewer if they expect the name of such Department also in the result.

If you want to be better in Analytics, then do follow the below Playlist:-

You can follow us on the below social media handles:-

[hasanmougharbel]

Hey man, glad to discover your channel.
I have a simple question as a new sql learner.
Could i use min() and max() with text data types?
Thanks for taking care of this.