No video :(

SQL Interview | Employee with closest salary to average salary in a department | nearest values

Подписаться 44 тыс.

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

50% 1

In this video, we discuss how to find employees having closest salary to average salary in a department.
The same approach can be used to find nearest values in a table.
Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org

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

21 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@Freakouts_and_found_Insane Год назад

Mind blowing ❤️👌

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

You are always posting great content. Thank you!

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

Glad you enjoy it!

@Ashutoshsingh-cw9wf Год назад

very good and helping content for the beginners. Thanks

@LearnatKnowstar Год назад

Glad it was helpful

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

Thank you for your efforts 🥺. Your videos are very helpful.

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

Thank you so much

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

this is a very tricky question ! lol great work !

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

SELECT X.*, ABS(X.SALARY - X.AVG_SAL) AS SAL_DIFF FROM ( SELECT E.*, AVG(E.SALARY) OVER(PARTITION BY E.DEPT_NAME) AS AVG_SAL FROM EMPLOYEE E) X ORDER BY X.DEPT_NAME, E.SAL_DIFF ASC; Why are you making the query complex. The above query hits DB once, no DF needed.

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

But this shouldn't be the complete query to get the same final output result. Guess I can use CTE for that. Thanks.

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

Great question! Thank you!

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

Glad it was helpful!

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

@@LearnatKnowstar Very helpful! thank you!

@saurabhyadav-nu3mj 2 года назад

Hi, great content, can you please make a video on fuzzy matching?

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

Thank you. Sure, we plan to cover it in upcoming videos!

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

Thanks.

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

Thank you

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

I wonder why you are scanning Employee table twice instead of using winowed function AVG() over (). This will allow to get same results in one scan

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

Please post the query here so ppl can benefit from it.

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

SELECT X.*, ABS(X.SALARY - X.AVG_SAL) AS SAL_DIFF FROM ( SELECT E.*, AVG(E.SALARY) OVER(PARTITION BY E.DEPT_NAME) AS AVG_SAL FROM EMPLOYEE E) X ORDER BY X.DEPT_NAME, E.SAL_DIFF ASC;