SQL Challenge Day #07 | SQL Interview Question

Published: 14 April 2024
on channel: EXCELMAP
163
11

This Video is About SQL Challenge Day #07. By Srinivas Reddy Excel Telugu Videos
#sql #excel #shorts #tranding #excelmap #mysql #sqlserver

/*List out the department wise max,
min, average salary of the employee */

SELECT *FROM EMPLOYEE
go

SELECT
DEPARTMENT_ID, COUNT(*) "No Of Emp",
MAX (SALARY) "Max Salary",
MIN (SALARY) "Min Salary",
AVG (SALARY) "Avg Salary"
FROM EMPLOYEE
Group by DEPARTMENT_ID

Please Follow us on Instagram:   / srinivasexcelmap  
Telegram: https://t.me/excelmap


On this page of the site you can watch the video online SQL Challenge Day #07 | SQL Interview Question with a duration of hours minute second in good quality, which was uploaded by the user EXCELMAP 14 April 2024, share the link with friends and acquaintances, this video has already been watched 163 times on youtube and it was liked by 11 viewers. Enjoy your viewing!