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

  Рет қаралды 12,841

The Data Millennials

The Data Millennials

Күн бұрын

Пікірлер: 7
@vsagar4b38
@vsagar4b38 Жыл бұрын
Thanks for Nice Explanation
@thedatamillennials
@thedatamillennials Жыл бұрын
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
@RajChoradiya
@RajChoradiya 5 күн бұрын
hi, can we use inner join instead of left join.
@hasanmougharbel8030
@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
@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
@omiticonsulting
@omiticonsulting Жыл бұрын
@@thedatamillennials Great explanation . Really appreciated
@thedatamillennials
@thedatamillennials 11 ай бұрын
thanks
SQL Query | How to find employees with highest salary in a department
10:38
Cheerleader Transformation That Left Everyone Speechless! #shorts
00:27
Fabiosa Best Lifehacks
Рет қаралды 13 МЛН
Thank you Santa
00:13
Nadir Show
Рет қаралды 59 МЛН
UFC 310 : Рахмонов VS Мачадо Гэрри
05:00
Setanta Sports UFC
Рет қаралды 1,1 МЛН
Do you love Blackpink?🖤🩷
00:23
Karina
Рет қаралды 25 МЛН
Part 1   How to find nth highest salary in sql
11:45
kudvenkat
Рет қаралды 1,9 МЛН
Infosys SQL Interview Question
9:23
Cloud Challengers
Рет қаралды 37 М.
Cheerleader Transformation That Left Everyone Speechless! #shorts
00:27
Fabiosa Best Lifehacks
Рет қаралды 13 МЛН