SQL Tutorial 2023 | Group By Statement and Group By Clause in SQL | Parnika Tutorial

Опубликовано: 16 Август 2022
на канале: Parnika Tutorials

379

"SQL Tutorial 2023 | Group By Statement and Group By Clause in SQL | PT

#GroupByStatement #GroupByClause #groupstatement #groupclause #sqlstatement #sqlclause #sqlgroupsstatement #sqlgroupclause #sqlserver #SQLServerTutorial #SQLTutorial2023 #SQL #SQLTraining #SQLServerTutorials #SQLServerCourse #sqltrainingvideos #sqlservertraining #sqlservertutorialvideos #SQLServer #parnikatutorials

00:13 - Group By Statement and Group By Clause
00:46 - single row function
03:00 - aggregate function
09:11 - generalized syntax group by clause
14:18 - group of multiple attributes
18:40 - having clause
27:18 - find the list of employes count of each job type
"
In this video, i have discussed about group by statement in sql

The GROUP BY statement groups rows that have the same values into summary rows, like "find the number of customers in each country".

The GROUP BY statement is often used with aggregate functions (COUNT(), MAX(), MIN(), SUM(), AVG()) to group the result-set by one or more columns.

GROUP BY Syntax
SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s)
ORDER BY column_name(s);

The following SQL statement lists the number of customers in each country:

Example
SELECT COUNT(CustomerID), Country FROM Customers GROUP BY Country;

The following SQL statement lists the number of customers in each country, sorted high to low:

Example
SELECT COUNT(CustomerID), Country FROM Customers GROUP BY Country
ORDER BY COUNT(CustomerID) DESC;

Social media Links:
Instagram:   / parnikatutorials
Website: http://parnikatutorials.in/
Email id: [email protected]
To get the regular updates:
Telegram link: https://t.me/Parnikatutorials
Facebook: https://m.facebook.com/profile.php?id...
Linkedin:   / parnika-tutorials-a8a9831b2
Pinterest:   / parnikatutorials0892
Playlists:
Virtual Coffee with Jagadeesh:
   • VIRTUAL COFFEE WITH JAGADEESH
Digital Logic Design:
   • Digital Logic Design
Computer Organization and Architecture:
   • ABOUT PARNIKA TUTORIALS
C Programming:
   • L 1: WHAT IS AN ALGORITHM AND CHARACT...
Data Structures:
   • L 1: Uncover the Benefits of Linked L...

Theory of Computation:
   • ABOUT PARNIKA TUTORIALS

Compiler Design:
   • ABOUT PARNIKA TUTORIALS
Operating Systems:    • PROCESS STATE DIAGRAM | LONG TERM, SH...

Databases:    • ABOUT PARNIKA TUTORIALS

Computer Networks:
   • ABOUT PARNIKA TUTORIALS
For GATE PYQs and much more explore:
   / parnikatutorials