21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN | Important Interview Query | COUNT(*)

  Рет қаралды 11,047

CodeEra

CodeEra

Күн бұрын

Are you new to SQL and looking to learn the basics quickly? Look no further! This tutorial is designed for beginners and will teach you the fundamentals of SQL .
So what are you waiting for? Grab your coffee and let's get started!
Complete SQL Tutorial Playlist- • SQL / MySQL Tutorial
📚 SQL Practice Questions -
codeera.netlif...
Key Moments-
Aggregate Functions - 00:40
COUNT() - 02:16
SUM() - 06:16
AVG() - 08:00
MIN() - 09:39
MAX() - 11:18
🔶Create Employee Table
codeera.netlif...
🔶Insert Data into Employee Table
codeera.netlif...
Connect with us on different platforms
✅ Visit Our Website: codeera.netlif...
✅ Subscribe us on KZbin: / @codeera2020
✅ Follow us on Instagram: / codeera_
✅ Follow us on Telegram: t.me/joingroup...
📌20 -TOP Clause in SQL | FETCH FIRST Clause
• 20 -TOP Clause in SQL ...
📌19- LIMIT and OFFSET in SQL
• 19- LIMIT and OFFSET i...
📌18- ORDER BY Clause in SQL
• 18- ORDER BY Clause in...
📌17-IS NULL & IS NOT NULL Operators | IFNULL() Function
• 17- IS NULL & IS NOT N...
📌16-LIKE & NOT LIKE Operator | Wildcard Characters | ESCAPE Character
• 16-LIKE Operator & Wil...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Interview SQL Query On Joins
• Interview SQL Query On...
⭐DBMS vs RDBMS
• DBMS vs RDBMS | What i...
⭐SQL Query To Swap Value Of Male and Female In Single Statement
• SQL Query To Swap Valu...
sql aggregate functions sum
sql aggregate function avg
sql aggregate function count
sql aggregate function min max
aggregate functions sql
aggregate functions in dbms
aggregate functions mysql
aggregate functions and grouping
aggregate functions in mysql
aggregate functions in sql
#sql
#sqlcourse
#sqlforbeginners
#datamanagement
#database
#sqltraining
#sqltutorial
#dataanalytics
#dataanalysis
#learnsql
#sqlqueries
#sqlprogramming
#onlinelearning
#techskills
#elearning
#onlinetraining
#programming
#coding
#careerdevelopment
#beginners
#MySQL
#databasemanagement
#DBMS
#techtutorials
#sqlforbeginners
#sqltutorial
#sqlcourse
#sqltraining
#simplilearn
#sqlintroduction
#sqlfullcourse
#oracledatabase
#oracle
#oraclesql
#ask4help
#learncoding
#clause
#sqlserver
#top
#sqlqueries
#aggregate

Пікірлер: 9
@Dr.KammilijaganMohan
@Dr.KammilijaganMohan Ай бұрын
Nice explanation. Thank you so much....
@javajugadcode1429
@javajugadcode1429 Жыл бұрын
Helpful videos 🎉
@CodeEra2020
@CodeEra2020 Жыл бұрын
Thank you so much. 😊
@mostaphadahmane7583
@mostaphadahmane7583 Жыл бұрын
Hello, my sweet teacher I hope you're doing well, I thank you so much for this helpful video and i hope you s good luck --- Mostapha from Algeria
@CodeEra2020
@CodeEra2020 Жыл бұрын
Thank you so much Mostapha. We are very glad that our videos helped you. Thank you so much for watching.
@it_21_debjitghosh42
@it_21_debjitghosh42 9 ай бұрын
Nice explanation 🙏
@sabarisabari1422
@sabarisabari1422 6 ай бұрын
Super explanation
@vitthalsabale7108
@vitthalsabale7108 Жыл бұрын
Hi Saloni, Thank you for sharing your SQL videos, it help lots of students who is beginner. I am getting below error while trying to find SUM or AVG salary from Department column using SUM & AVG functions on SQL server Msg 8117, Level 16, State 1, Line 27 Operand data type varchar is invalid for sum operator.
@CodeEra2020
@CodeEra2020 Жыл бұрын
Please share your SQL query
SQL Aggregate Window Functions | COUNT, AVG, SUM, MAX, MIN | #SQL Course #4
1:07:34
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН
So Cute 🥰 who is better?
00:15
dednahype
Рет қаралды 19 МЛН
Querying 100 Billion Rows using SQL, 7 TB in a single table
9:07
Arpit Agrawal (Elastiq.AI)
Рет қаралды 61 М.
Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)
5:44
Becoming a Data Scientist
Рет қаралды 99 М.
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2,2 МЛН
Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)
6:00
Becoming a Data Scientist
Рет қаралды 276 М.
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Anton Putra
Рет қаралды 258 М.
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Database Star
Рет қаралды 101 М.
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН