Тёмный

Find the number of Employees working in each department | SQL Interview Question | Most Asked Query 

CodeEra
Подписаться 33 тыс.
Просмотров 22 тыс.
50% 1

Want to know ,How to find Number of employee working in each department? .So just watch the video now.
Please Like , share and subscribe.
Join our Telegram Channel - t.me/joingroup...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Find Nth Highest Salary in SQL | 5 Different Ways
• Find Nth Highest Salar...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Types of Joins in SQL-
• SQL Joins & Its Types ...
⭐Aggregate Functions In SQL | COUNT, SUM, AVG, MIN, MAX | IFNULL( )
• Aggregate Functions In...
⭐Difference Between DELETE, DROP and TRUNCATE
• Difference Between DEL...
⭐SQL vs NoSQL | MySQL vs MongoDB
• Difference between SQL...
⭐DBMS vs RDMS
• DBMS vs RDBMS | What i...
⭐Normalization in DBMS-
• Normalization and its ...
⭐Types of key in DBMS-
• Types of Keys in DBMS ...
⭐Create MySQL Database and Table -
• How to Create Database...
#mysql #oracle #dbms #query #top #sqlserver #database #PlacementPreparation

Наука

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

 

29 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 20   
@Manojkumarprathima
@Manojkumarprathima 2 года назад
How can this query works in select clause you have taken dept_name and group by clause you have taken dept_id
@vishalwagh8800
@vishalwagh8800 2 года назад
query not working without join as you select dept_name , it will not project dept_name
@kalki1168
@kalki1168 Год назад
How to get the name of emplyees working in different department
@SadabKhan-zd9ts
@SadabKhan-zd9ts 3 месяца назад
This same question how to solve subquery please tell me mam
@jaymahajan3871
@jaymahajan3871 3 года назад
V very good
@radhasakhi4546
@radhasakhi4546 3 года назад
Nice video
@myradhachannel1176
@myradhachannel1176 3 года назад
Very nice , good
@timeloop9495
@timeloop9495 3 года назад
Please make videos on Oracle SQL and PL/SQL.
@sumitpanday7812
@sumitpanday7812 8 месяцев назад
Find the minimum age of employees in each department. Expected output: departement, age, the output should be sorted by department in ascending order
@palakmahajan9999
@palakmahajan9999 3 года назад
it's a very nice video
@Subbu_Sanju007
@Subbu_Sanju007 5 месяцев назад
how to get all emp information using department table
@truptividhate7494
@truptividhate7494 3 года назад
Every videos are well explained. Please upload videos on Oracle DBA concepts along with Unix/ linux concepts as well .
@CodeEra2020
@CodeEra2020 3 года назад
Thank you so much for watching.. We will try our best to provide you required videos..
@jayakumar2927
@jayakumar2927 Год назад
why we mention group dept_id our select query not presented deptid
@rnsbakhietrm5914
@rnsbakhietrm5914 2 года назад
Thank you, Thank you and Thank you.
@CodeEra2020
@CodeEra2020 2 года назад
You are very welcome
@ananthnath1976
@ananthnath1976 2 года назад
Please upload videos on Infomatica power center
@vishalwagh8800
@vishalwagh8800 2 года назад
it will show group by function
@aathershachu6093
@aathershachu6093 2 года назад
Asked to me
Далее
Офицер, я всё объясню
01:00
Просмотров 4 млн
Samsung копирует Apple?
0:36
Просмотров 1,4 млн