Back to Browse

15. Group by IN SQL | SQL TUTORIAL

2.0K views
Oct 22, 2024
5:19

SQL GROUP BY Explained: Master Data Aggregation! In this video, learn how to use the GROUP BY clause in SQL to organize and aggregate data effectively. πŸ“Šβœ¨ βœ… What is GROUP BY? The GROUP BY clause groups rows that share the same values in specific columns. It’s often combined with aggregate functions like SUM(), COUNT(), AVG(), MIN(), and MAX() to summarize data. Want more similar videos- hit like, comment, share and subscribe ❀️Do Like, Share and Comment ❀️ ❀️ Like Aim 5000 likes! ❀️ βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– script CREATE TABLE EMPL ( ID INT, NAME VARCHAR (17), SALARY INT, LOCATION VARCHAR(17), DEPT VARCHAR(17) ) INSERT INTO EMPL VALUES (1,'MANISH', 900000,'INDIA','SDE') INSERT INTO EMPL VALUES (2,'RANI', 1000000,'INDIA','SDE2') INSERT INTO EMPL (ID ,NAME,SALARY,DEPT) VALUES (3,'RAJ', 700000,'SALES') INSERT INTO EMPL(ID ,NAME,SALARY,DEPT) VALUES (4,'RAHUL', 600000,'HR') βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– AWS DATA ENGINEER : https://www.youtube.com/playlist?list=PLOlK8ytA0MghpdMjb0m9zu1v9s_qbRP0q Azure data factory : https://youtube.com/playlist?list=PLOlK8ytA0MgguN5XidtQXbILxwCdJCUJE&si=iEICXHP80zGchUYh Azure data engineer playlist : https://youtube.com/playlist?list=PLOlK8ytA0MghBrzu0i6WlTBdoO1WdwV_e SQL PLAYLIST : https://www.youtube.com/playlist?list=PLOlK8ytA0MggGXIKmbfZ-_Xqcos3JKdV- PYSPARK PLAYLIST - https://www.youtube.com/playlist?list=PLOlK8ytA0MgjvOpd-088NRU_vTYw_aryH βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– πŸ“£Want to connect with me? Check out these links:πŸ“£ Join telegram to discuss https://t.me/+Cb98j1_fnZs3OTA1 βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– what we have covered in this video: βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž– Hope you liked this video and learned something new :) See you in next video, until then Bye-Bye! βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–βž–

Download

0 formats

No download links available.

15. Group by IN SQL | SQL TUTORIAL | NatokHD