Use Of GROUP BY Clause In SQL | Interview Questions | Examples

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

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

50% 1

In this video we will learn to us GROUP BY Clause in SQL with help of 5 different use cases of Group By Clause along with query practice.
Please Like 👍, Share and Subscribe.
Query PDF To Create Table And Add Data Into Table -
drive.google.com/file/d/1djzC...
Join our Telegram Channel - t.me/joingroupCodeEra
⭐Constraints In SQL | Part-I
• Constraints In SQL | ...
⭐Constraints In SQL | Part-II
• Constraints In SQL | ...
⭐How To Delete Duplicate Rows In a Table
• How To Delete Duplicat...
⭐How To Find Duplicate Rows In a Table
• How To Find Duplicate ...
⭐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...
⭐Find the number of Employees working in each department | SQL
• Find the number of Emp...
⭐Types of Joins in SQL-
• SQL Joins & Its Types ...
⭐Difference Between WHERE and HAVING Clause
• Difference Between WHE...
⭐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...
#sql #GroupByClause #Having #GroupBy #sqlserver #database #mysql #PlacementPreparation

Наука

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

7 окт 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

answers: 1. select department , max(salary) from employee_info group by department; 2. select gender ,count(id) from employee where dob between 01/01/1960 AND 31/12/1975 group by gender; 3. select department , count(id) from employee_info group by department; Please check my queries @CodeEra :) Thanks

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

Yeah Its Correct. Thank you for watching

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

@@CodeEra2020 how 🙄, data must be written in ' ' quotes ....recheck it..

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

@@sachinupreti7159 date is different data type.Not string not int.

@shabbiulhassan9677 Год назад

2. select gender ,count(id) from employee where dob between 01/01/1960 AND 31/12/1975 group by gender; Shouldn't we use HAVING clause instead of WHERE here?

@PenApostol 11 месяцев назад

@@shabbiulhassan9677having is used for aggregate functions

@mejawad6673 Год назад

Thanks for your excellent videos based on scenarios. Helps me a lot

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

Thank you, nice explanatiom

@prathapganesh7021 8 месяцев назад

Thank you for the video

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

Great work..Pls take full SQL course from beginners.. it is very useful to them to crack the interview

@SaumyaSharma007 11 месяцев назад

God bless you 🙂🙏

@gollangianand6378 Год назад

TQQ madam very useful &easy to understand

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

Thank you so much for giving the vertical view of table after group by is used. The view made it so easy to understand. In no other video I found this. Thank you so much sister.

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

I am so glad you the video. Thank you so much for watching

@ptechsolutions9575 Месяц назад

Very helpful

@subbarayudu118 Год назад

Thank you madam

@explorenewsee2815 Год назад

Nice 👍

@adityashekharsingh2669 Год назад

helpful!!

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

Very helpful and you explain in very simple manner . Thank you👍

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

Thank you.

@pradyumansinghshekhawat7364 Год назад

very well structured lecture Explained thoroughly ❤

@CodeEra2020 Год назад

Thank you so much😊

@AnilKumar-cl4hp 2 года назад

I am your New subscriber

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

Thank you it really helps

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

So glad to know that It helps you.. Thank you for watching

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

Very well explained Mam thanks.

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

Thank you so much.

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

Thank you so much...

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

Welcome. We're so happy that you like the video. Thanks for watching

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

Is it always necessary to include those columns in "group by" which are used after Select? For ex: Select col1, col2 from table group by col1. In this above query do we also need to include col2 in group by as it is there after Select. Could you please confirm this point.

@MRBLACK-id7zk 2 года назад

Great

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

Thank you so much

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

Null value it is display y as its sum is less than 17 k in the vedio at 10.20

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

Null is in Department column not in SUM(Salary) Column

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

Nice video Didi

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

Thanks for liking

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

Hello, Hello,Great work you are doing in computer training. I am generating reports and i have challenges in using using sum and group by in my sql querries. Could you kindly offer some help i am stuck on these . Your help is much appreciated. David

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

What difficulty are you facing?

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

Nice

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

Thank you so much

@vineelsai111 11 месяцев назад

select department,max(salary) from employee_info group by department; select count(*),gender from employees group by gender having dob between '1960-01-10' and '1975-12-31'; select count(*),department from employees group by department;

@kiranharijan2809 Год назад

Madam for practice purspose can you plz provide more questions on sql

@CodeEra2020 Год назад

Sure,we will.

@sujin8380 Год назад

Why using aggrigate function in group by

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

why in the output result at 11.25, NULL is not displayed although it has sum(salary) as 87000 which is greater than 17000

@jeneetaaslam Год назад

Same doubt :(

@bharatkumarboddepalli6095 Год назад

there is a small mistake in data set .....department constraint cant be "NOT NULL" while creating table .

@AnjaliMathur-dr5ui Месяц назад

1) select max(Salary), department from employee_info group by department; 2) select count(ID), gender from employee_info where DOB between 01/01/1960 and 31/12/1975 group by gender; 3)select count(ID) , department from employee_info group by department;