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

Подписаться 4,1 тыс.

Просмотров 12 тыс.

50% 1

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:-
Excel Playlist:- • What is MS Excel | Int...
SQL Playlist:- • Introduction to SQL | ...
Google Data Studio playlist:- • Introduction to Looker...
You can follow us on the below social media handles:-
Blog: - thedatamillenn...
Facebook:- / the-data-millennials-5...
Instagram: - / the_data_millennials
LinkedIn: - / data-millennials-6b5a0...
Twitter: - / datamillennials

Опубликовано:

29 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 6

@vsagar4b38 Год назад

Thanks for Nice Explanation

@thedatamillennials 11 месяцев назад

apologies for the delayed response. I am Glad that our video was useful and helpful . Request you to please check out our other videos of Excel, SQL and Google data studio ( Looker) and also please help us to reach out to all your friends and family members who might want to learn something new by sharing our content. And Request you to please subscribe our channel to learn more about such topics

@hasanmougharbel8030 2 года назад

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.

@thedatamillennials 2 года назад

Hi Hasan, You can use the min() and max() function with text data type and the max function will return text values in descending order(text starts with z will come on 1st row ) while the min function will return text values in ascending order(text starts with a will come on 1st row ). Example of query is mentioned below. select max(Employee_name) from sql_interview.emp_vv1; ------> Result is Waseem select min(Employee_name) from sql_interview.emp_vv1; ------> Result is Atul