Database Management Exam > Database Management Videos > Microsoft SQL for Beginners > SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS
SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS Video Lecture | Microsoft SQL for Beginners - Database Management
FAQs on SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS Video Lecture - Microsoft SQL for Beginners - Database Management
| 1. What is the purpose of the GROUP BY clause in SQL? |  |
Ans. The GROUP BY clause is used in SQL to group rows that have the same values in a specific column or set of columns. It is often used in conjunction with aggregate functions like SUM, COUNT, AVG, etc., to perform calculations on grouped data.
| 2. How does the GROUP BY clause work with SQL JOINS? | |
Ans. When using the GROUP BY clause with SQL JOINS, the data from multiple tables is combined based on the join condition, and then the grouped data is returned. This allows us to perform calculations and aggregate functions on the combined data from multiple tables.
| 3. Can we use multiple columns in the GROUP BY clause? | |
Ans. Yes, we can use multiple columns in the GROUP BY clause. When multiple columns are specified, the rows are grouped based on the unique combinations of values in those columns. This allows for more specific grouping and analysis of the data.
| 4. What is the difference between the WHERE clause and the GROUP BY clause? | |
Ans. The WHERE clause is used to filter rows based on specific conditions before grouping them, while the GROUP BY clause is used to group rows together based on common values in one or more columns. The WHERE clause filters the data, while the GROUP BY clause organizes the filtered data.
| 5. Can we use aggregate functions without the GROUP BY clause? | |
Ans. Yes, we can use aggregate functions without the GROUP BY clause. When aggregate functions are used without the GROUP BY clause, they treat the entire result set as a single group and calculate the aggregate value for that group. This is helpful when we want to perform calculations on the entire result set rather than grouped data.
Text Transcript from Video
hello guys welcome to my channel this is
the 30th tutorial in this course and in
this video we are going to see how we
can use the group by clause while
performing the join operation on a
couple of tables so the tables that we
are going to use you know are the same
tables with which we worked in the
previous tutorial the tutorial table and
read or underscore info table and we now
know what kind of information we have in
both the tables and we perform the join
operation on them so we know how to use
a you know the join and the on and you
know all the clauses so you know this
this example is going to be an extension
of what we did in the last tutorial and
it's going to be pretty simple so let's
say I want you know to pull out subject
information from the Detroit table and
views and likes data from the Detroit
underscore info table so since we have
you know two tables with which we're
going to work so you know we'll have to
obviously perform you know a join on
them now let's say I also want to see
you know the total number of views that
all the tutorials in the C playlist have
accumulated and the total number of
views and likes that all tutorials in
the shell scripting playlist have
accumulated and you know total number of
views and likes that all tutorials in
the SQL playlist have accumulated so
obviously I'll be grouping the tutorials
on the basis of the you know subject
value right so you know all the sub all
the C tutorials have to be grouped
together and all the SQL tours have to
be grouped together and then we'll be
adding the views and likes you know data
for all the tutorials and we'll be
displaying that data so let's get
started so I'll first have to type in
select write that is 0 we have to use a
select query of course and then T dot
subject and as in the previous tutorial
I will be the 4 into the tutorial table
as T site and subject here is the name
of the you know feel that hold subject
values in the Detroit table and then
I'll type in sum which is an aggregate
function and you know we haven't checked
this function out in this course thus
far and I intend on recording a separate
tutorial on aggregate functions but for
the time being just know that you know
it adds numeric
values right so I'll type in T I dot
view x' within parentheses right and
then I want to see this
as a total view so I will type in that
within single quotes total space views
and let's say I also want to see the
total number of likes so I'll type in
some again and within parenthesis I will
pass T I dot likes as the argument and
I'll type in the ASCII word again and I
want to see this as a total Lights try
it and then on the next line I'll type
in the from keyboard and I'll type in
the name of the first table which is
tutorial as T and then on the next line
I'll type in the join keyword and type
in the name of the second table which is
tutorial underscore info as TI and then
on the next line I'll type in on and the
condition which is T dot ID equals T i
dot tutorial underscore ID right and
then on the next line I'll type in
group-by and since we want you know
tutorials to be grouped or you know in
two groups on the basis of the values in
the subject column in the tutorial table
I'll type in T dot subject here right
I'll put in a semicolon at the end to
terminate the query and when I press
control enter I see that I get three
rows for the three different values that
the subject column the tutorial table
holds so I've got C shell scripting and
SQL as the three subjects a total number
of views of all tutorials in the C
playlist are you know two three to seven
triple 0 total number of views of all
tutorials in the shell scripting
playlist well that's this and then told
them reviews for tutorials in the SQL
playlist is this and then we also have
data for you know total number of likes
so that's how you group by data you know
that belongs to two different tables so
you know the if you understand the group
by operation
as well as the joint operation you know
if you understand how those things
fundamentally work then I don't think
it's going to be much complicated for
you to you know put them together into a
single query right so I hope you guys
had fun watching this one and join
operation was actually you know the
default join is the inner join and the
inner join does not take into account
null values that are present in tables
but you also have outer joins like right
and left we're going to check them out
maybe in the next couple of tutorials
and you know those joins of take into
account null values and you know we'll
be seeing them and but that's for the
next few tutorials and for this one I
just wanted to discuss this example so
thank you so much and you may subscribe
to my channel if you haven't already and
take care and I'll see you soon
the 30th tutorial in this course and in
this video we are going to see how we
can use the group by clause while
performing the join operation on a
couple of tables so the tables that we
are going to use you know are the same
tables with which we worked in the
previous tutorial the tutorial table and
read or underscore info table and we now
know what kind of information we have in
both the tables and we perform the join
operation on them so we know how to use
a you know the join and the on and you
know all the clauses so you know this
this example is going to be an extension
of what we did in the last tutorial and
it's going to be pretty simple so let's
say I want you know to pull out subject
information from the Detroit table and
views and likes data from the Detroit
underscore info table so since we have
you know two tables with which we're
going to work so you know we'll have to
obviously perform you know a join on
them now let's say I also want to see
you know the total number of views that
all the tutorials in the C playlist have
accumulated and the total number of
views and likes that all tutorials in
the shell scripting playlist have
accumulated and you know total number of
views and likes that all tutorials in
the SQL playlist have accumulated so
obviously I'll be grouping the tutorials
on the basis of the you know subject
value right so you know all the sub all
the C tutorials have to be grouped
together and all the SQL tours have to
be grouped together and then we'll be
adding the views and likes you know data
for all the tutorials and we'll be
displaying that data so let's get
started so I'll first have to type in
select write that is 0 we have to use a
select query of course and then T dot
subject and as in the previous tutorial
I will be the 4 into the tutorial table
as T site and subject here is the name
of the you know feel that hold subject
values in the Detroit table and then
I'll type in sum which is an aggregate
function and you know we haven't checked
this function out in this course thus
far and I intend on recording a separate
tutorial on aggregate functions but for
the time being just know that you know
it adds numeric
values right so I'll type in T I dot
view x' within parentheses right and
then I want to see this
as a total view so I will type in that
within single quotes total space views
and let's say I also want to see the
total number of likes so I'll type in
some again and within parenthesis I will
pass T I dot likes as the argument and
I'll type in the ASCII word again and I
want to see this as a total Lights try
it and then on the next line I'll type
in the from keyboard and I'll type in
the name of the first table which is
tutorial as T and then on the next line
I'll type in the join keyword and type
in the name of the second table which is
tutorial underscore info as TI and then
on the next line I'll type in on and the
condition which is T dot ID equals T i
dot tutorial underscore ID right and
then on the next line I'll type in
group-by and since we want you know
tutorials to be grouped or you know in
two groups on the basis of the values in
the subject column in the tutorial table
I'll type in T dot subject here right
I'll put in a semicolon at the end to
terminate the query and when I press
control enter I see that I get three
rows for the three different values that
the subject column the tutorial table
holds so I've got C shell scripting and
SQL as the three subjects a total number
of views of all tutorials in the C
playlist are you know two three to seven
triple 0 total number of views of all
tutorials in the shell scripting
playlist well that's this and then told
them reviews for tutorials in the SQL
playlist is this and then we also have
data for you know total number of likes
so that's how you group by data you know
that belongs to two different tables so
you know the if you understand the group
by operation
as well as the joint operation you know
if you understand how those things
fundamentally work then I don't think
it's going to be much complicated for
you to you know put them together into a
single query right so I hope you guys
had fun watching this one and join
operation was actually you know the
default join is the inner join and the
inner join does not take into account
null values that are present in tables
but you also have outer joins like right
and left we're going to check them out
maybe in the next couple of tutorials
and you know those joins of take into
account null values and you know we'll
be seeing them and but that's for the
next few tutorials and for this one I
just wanted to discuss this example so
thank you so much and you may subscribe
to my channel if you haven't already and
take care and I'll see you soon
Related Exams
About this Video
|
4.73/5 Rating |
|
Nov 25, 2024 Last updated |
Video Description: SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS for Database Management 2024 is part of Microsoft SQL for Beginners preparation.
The notes and questions for SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS have been prepared according to the Database Management exam syllabus.
Information about SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS covers all important topics for Database Management 2024 Exam.
Find important definitions, questions, notes, meanings, examples, exercises and tests below for SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS.
Introduction of SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS in English is available as part of our Microsoft SQL for Beginners for Database Management & SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS in
Hindi for Microsoft SQL for Beginners course. Download more important topics related with notes, lectures and mock test series for
Database Management Exam by signing up for free.
Description
Video Lecture & Questions for SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS Video Lecture | Microsoft SQL for Beginners - Database Management - Database Management full syllabus preparation | Free video for Database Management exam to prepare for Microsoft SQL for Beginners.
Information about SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS
Here you can find the meaning of SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS defined & explained in the simplest way possible.
Besides explaining types of SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS theory, EduRev gives you an ample number of questions to practice SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS tests,
examples and also practice Database Management tests.
|
Explore Courses for Database Management exam
|
|
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
Related Searches
Semester Notes
,past year papers
,study material
,SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS Video Lecture | Microsoft SQL for Beginners - Database Management
,Objective type Questions
,Extra Questions
,SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS Video Lecture | Microsoft SQL for Beginners - Database Management
,Summary
,mock tests for examination
,Sample Paper
,Important questions
,practice quizzes
,ppt
,video lectures
,shortcuts and tricks
,Viva Questions
,Previous Year Questions with Solutions
,MCQs
,Exam
,Free
,SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS Video Lecture | Microsoft SQL for Beginners - Database Management
;
Study SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS on the App
Students of Database Management can study SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS alongwith tests & analysis from the EduRev app,
which will help them while preparing for their exam. Apart from the SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS,
students can also utilize the EduRev App for other study materials such as previous year question papers, syllabus, important questions, etc.
The EduRev App will make your learning easier as you can access it from anywhere you want.
The content of SQL Tutorial - 30: Using GROUP BY Clause with SQL JOINS is prepared as per the latest Database Management syllabus.
|
© EduRev
|
Education Revolution
|
Follow Us
|
Signup to see your scores
go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup