In this tutorial we'll see how we can use the Group By clause with Joins in SQL.
Пікірлер: 31
@irshaadmohammed9024 Жыл бұрын
Hey bro dont lsiten to them, your voice isn;t annoying. your explanation is very clear and now I have a clearer concept of joins.
@cozimbatman41009 жыл бұрын
pretty cool how you combined them to show u the table like that
@marijuanastoner277 жыл бұрын
in case you want to avoid creating tables please refert these are the table USE test ; CREATE TABLE tutorial (id int primary key, tittle nvarchar(30),Subject nvarchar(30),duration decimal(4,2) ,uploaddate date); CREATE TABLE tutorial_info (tutorial_id int primary key,Views int,likes int,dislikes int,shares int); INSERT INTO tutorial (id,tittle,Subject,duration,uploaddate) VALUES (1,'Select query','SQL',4.56,'2013-08-08'), (2,'inser query','SQL',5.32,'2013-08-08'), (3,'arithmetic operation','SQL',6.37,'2013-08-08'), (4,'Logical operation','SQL',5.11,'2013-08-08'), (5,'Order by clause','SQL',4.19,'2013-08-08'), (6,'Function','C',5.23,'2013-04-04'), (7,'Structure','C',4.26,'2013-04-04'), (8,'While loop','C',8.13,'2013-04-04'), (9,'For loop','C',5.30,'2013-04-04'), (10,'Break statement','C',7.62,'2013-04-04'), (11,'Continuous statement','C',6.56,'2013-04-04'), (12,'Unions','C',3.21,'2013-04-04'), (13,'Typedef','C',7.86,'2013-04-04'), (14,'Is command','Shell script',3.19,'2013-01-01'), (15,'Pwd command','Shell script',2.79,'2013-01-01'), (16,'Grep command','Shell script',4.77,'2013-01-01'), (17,'Who command','Shell script',6.13,'2013-01-01'); INSERT INTO tutorial_info(tutorial_id,Views,likes,dislikes,shares) VALUES (1,15000,54,13,6), (2,17500,43,21,2), (3,12500,31,29,12), (4,16000,17,0,11), (5,85000,117,10,19), (6,112000,191,46,34), (7,85000,106,25,8), (8,91000,166,24,17), (9,191000,846,48,32), (10,235000,1170,93,52), (11,454000,2070,117,63), (12,515000,2900,131,96), (13,644000,3280,137,12), (14,644000,3280,137,12), (15,329000,1115,143,7), (16,147589,650,22,3), (17,22222,114,12,7), (23,45000,650,131,11), (24,57850,784,46,17), (25,313000,1185,163,19);
@madhurbhatia897 жыл бұрын
+Pramod Nair Thanks Pramod, this should help some viewers.
@marijuanastoner277 жыл бұрын
Thank you Madhur sir Im from a non it background and wanted to switch into IT field, have been struggling with SQL for a long time , but your video series were 'purely amazing taught me everything basic thank you for your noble cause India needs tutors like you , just wanted to ask you could do some more videos on joins and triggers . Nice beard :p
@sukhvindersingh61855 жыл бұрын
Thanks Brother
@SquareRoot_2 жыл бұрын
This is why every single tutorial tells you to name variables with proper names. Most likely self-taught at the time.
@jaganmohan41609 ай бұрын
Can you please share a tutorial how to use joins on tables where tables are present in different data base using joins .....it will be very help full
@bartd80d7 ай бұрын
Where can I get the source database for this exercise? Cos I would like to do it myself, thx.
@diptijain Жыл бұрын
Thank you
@leonghchan3 жыл бұрын
How do you find the number of groups (subjects) you have? For example, in this case, the answer will be three.
@paritoshsingh5883 жыл бұрын
Select count(subject) from t;
@sheru53079 ай бұрын
acha se samjha bv
@Sandy-no1up9 жыл бұрын
what will happen if we put the exact command but not the last line i.e the group by command...???
@yashvardhangiri5023 жыл бұрын
Thanks bro
@PatienceMTJANE3 жыл бұрын
what do you use to execute your SQL statement ? it looks better than SQL command line
@maan_19_ Жыл бұрын
'Run' command usually. I think he's clicking enter
@lucianocorrea48236 жыл бұрын
Tables are not visible....
@niteshmishra41229 жыл бұрын
We can not perform join on two tables without giving Alias name ?
@timchunk12487 жыл бұрын
I guess yes?
@shobhamahadev1185 жыл бұрын
No. We can perform without giving alias name also.
@ae15508 жыл бұрын
Code returns same results when using ( GROUP BY subject) instead of (GROUP BY t.subject)
@Silviu6247 жыл бұрын
Yes, it is working that way too because in both tables ( tutorial and tutorial_info ) is only one column named subject. But if both tables had their own column named subject, using the t.subject points exactly to the column you want to access.
@itreportcambodia82833 жыл бұрын
hello b
@johnrobertsonnocos29966 жыл бұрын
Too much useless talk 😒
@amitapatil91255 жыл бұрын
Why do you speak too much??
@domxon3 жыл бұрын
Bakwass
@shubhshubham33997 жыл бұрын
you speak so much of unwanted things with a very irritating voice. The only reason I prefer your series is the good subject content. But please stop talking such a lot in vein.