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

[@vsagar4b38]

Thanks for Nice Explanation

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

[@hasanmougharbel8030]

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]

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]

@@thedatamillennials Great explanation . Really appreciated

[@thedatamillennials]

thanks