In this video we have discussed very important concepts in SQL i.e. aggregate functions, group by clause and having clause in SQL. In this video we have seen many examples where we can use various aggregate functions like MIN, MAX, COUNT, SUM, AVG. Also we have seen where to use group by and where to use Having. Please like and share this video with your friends.
What is a Scalar function : 0:58
What is Aggregate function: 02:00
MIN() : 2:55
MAX() : 03:32
SUM(): 03:58
COUNT(): 04:36
AVG() : 05:34
GROUP BY clause: 06:09
HAVING clause: 12:02
Please like & share the video.
Subscribe the Channel to keep watching interesting videos helpful for your career growth:
/ @codingglitz
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout different playlists:
PLSQL Tutorial : • PLSQL Tutorial || PL SQL tutorial for...
Learn DBMS & SQL : • SQL Tutorial for Beginners || SQL Pla...
SQL Interview Questions and answers: • sql interview questions and answers i...
Java Interview Questions and Answers : • JAVA Programs for interview
IT Career guidance: • Career Guidance
Interview Tips : • Interview Tips
IT Essentials and Tricks : • IT Essentials and Tricks
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout Important videos :
Top 30 SQL Queries Interview Questions and Answers : • SQL Queries Interview Questions and a...
Top 50 SQL Concepts Interview Questions and Answers : • SQL Interview Questions And Answers
SQL JOINS : • SQL Joins With Examples | SQL Joins T...
SUB QUERY : • Subquery in SQL || SQL Subquery tutor...
Employee earning maximum salary in each department query : • SQL Query to find Employee with maxim...
How to delete duplicate rows from any table (2 different solutions): • SQL query to delete duplicate rows in...
How to find Nth highest salary (3 different solutions): • SQL query to find Nth Highest salary ...
Tricky SQL Queries Part1 : • SQL Tricky and Important Interview Qu...
Basics of Database : • What is DBMS? Learn Basics of DBMS |...
SQL OPERATORS : • Operators in SQL || SQL Tutorial for...
AGGREGATE FUNCTION: • Aggregate function || SQL Tutorial f...
GROUP BY : • GROUP BY & HAVING || SQL Tutorial fo...
Solve any Date related query : • How to Solve any SQL Query related to...
How to use Substring : • Substrings in SQL | Learn SQL | SQL ...
How to practice SQL Queries in local / Install Database in local : • How to Install Oracle Database (19C) ...
IT Jobs without Coding : • IT Jobs without coding with high sala...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------