Use Of GROUP BY Clause In SQL | Interview Questions

No video

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

Рет қаралды 28,259

Күн бұрын

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.c...
Join our Telegram Channel - t.me/joingroup...
⭐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

Пікірлер: 51

@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 Жыл бұрын

@@shabbiulhassan9677having is used for aggregate functions

@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

@mejawad6673 2 жыл бұрын

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

@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😊

@ptechsolutions9575 2 ай бұрын

Very helpful

@vineelsai111 Жыл бұрын

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;

@SaumyaSharma007 Жыл бұрын

God bless you 🙂🙏

@hdmovies9432 2 жыл бұрын

Thank you it really helps

@CodeEra2020 2 жыл бұрын

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

@potnurinagamohan3556 2 жыл бұрын

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

@nakulanand2725 2 жыл бұрын

Very well explained Mam thanks.

@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

@MRBLACK-id7zk 2 жыл бұрын

Great

@CodeEra2020 2 жыл бұрын

Thank you so much

@gollangianand6378 Жыл бұрын

TQQ madam very useful &easy to understand

@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?

@radhasakhi4546 2 жыл бұрын

Nice video Didi

@CodeEra2020 2 жыл бұрын

Thanks for liking

@prathapganesh7021 9 ай бұрын

Thank you for the video

@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.

@AnjaliMathur-dr5ui 3 ай бұрын

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;