14. Aggregate Function IN SQL | sql tutorial
SQL Aggregate Functions Explained: Summarize Your Data! In this video, explore the most popular aggregate functions in SQL and how they help you summarize and analyze data efficiently! ๐๐ โ What are Aggregate Functions? Aggregate functions perform calculations on multiple rows and return a single value MIN , MAX , AVG , COUNT , SUM IN SQL 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 formatsNo download links available.