No video

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

  Рет қаралды 21,061

CodeEra

CodeEra

Күн бұрын

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

Пікірлер: 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
@jaymahajan3871
@jaymahajan3871 3 жыл бұрын
V very good
@myradhachannel1176
@myradhachannel1176 3 жыл бұрын
Very nice , good
@radhasakhi4546
@radhasakhi4546 3 жыл бұрын
Nice video
@sumitpanday7812
@sumitpanday7812 6 ай бұрын
Find the minimum age of employees in each department. Expected output: departement, age, the output should be sorted by department in ascending order
@timeloop9495
@timeloop9495 3 жыл бұрын
Please make videos on Oracle SQL and PL/SQL.
@palakmahajan9999
@palakmahajan9999 3 жыл бұрын
it's a very nice video
@rnsbakhietrm5914
@rnsbakhietrm5914 2 жыл бұрын
Thank you, Thank you and Thank you.
@CodeEra2020
@CodeEra2020 2 жыл бұрын
You are very welcome
@vishalwagh8800
@vishalwagh8800 2 жыл бұрын
query not working without join as you select dept_name , it will not project dept_name
@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..
@kalki1168
@kalki1168 Жыл бұрын
How to get the name of emplyees working in different department
@Subbu_Sanju007
@Subbu_Sanju007 4 ай бұрын
how to get all emp information using department table
@ananthnath1976
@ananthnath1976 2 жыл бұрын
Please upload videos on Infomatica power center
@vishalwagh8800
@vishalwagh8800 2 жыл бұрын
it will show group by function
@jayakumar2927
@jayakumar2927 Жыл бұрын
why we mention group dept_id our select query not presented deptid
@aathershachu6093
@aathershachu6093 2 жыл бұрын
Asked to me
@SadabKhan-zd9ts
@SadabKhan-zd9ts 2 ай бұрын
This same question how to solve subquery please tell me mam
小丑把天使丢游泳池里#short #angel #clown
00:15
Super Beauty team
Рет қаралды 48 МЛН
Or is Harriet Quinn good? #cosplay#joker #Harriet Quinn
00:20
佐助与鸣人
Рет қаралды 20 МЛН
مسبح السرير #قصير
00:19
سكتشات وحركات
Рет қаралды 3,1 МЛН
Running With Bigger And Bigger Feastables
00:17
MrBeast
Рет қаралды 170 МЛН
SQL Index |¦| Indexes in SQL |¦| Database Index
9:57
Socratica
Рет қаралды 614 М.
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,5 МЛН
小丑把天使丢游泳池里#short #angel #clown
00:15
Super Beauty team
Рет қаралды 48 МЛН