Lec-67: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS

Показать описание

0:00 - Introduction
1:16 - MAX
3:25 - MIN
4:20 - COUNT
6:52 - SUM
8:13 - AVG

► Structured Query Language (SQL)(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Database Management System(Complete Playlist):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

Рекомендации по теме

Комментарии

Great video! Kudos to you, sir!
Just a few corrections though:
1. Instead of SELECT DISTINCT(COUNT Salary) FROM Emp;, the query should be SELECT COUNT(DISTINCT Salary) FROM Emp;
2. Similarly, instead of SELECT DISTINCT(SUM Salary) FROM Emp;, the query should be SELECT SUM(DISTINCT Salary) FROM Emp;, and
3. Instead of SELECT DISTINCT(AVG Salary) FROM Emp;, the query should be SELECT AVG(DISTINCT Salary) FROM Emp;

deepikajuneja

It was a great video to learn SQL, Between kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee; Thank you.

bipulkumar

6:40 SELECT COUNT( DISTINCT Salary) FROM Emp; is the correct answer.

aaryangarhewal

I came across ur videos. And I swear u made my life easier. I wanted to join SQL classes, however couldn't join right now due to financial condition.. And I started following ur videos. I don think I need any coaching outside. Thanks sir.

eshas

select sum ( distinct ( salary ) ) from emp;
cos first we have to distinct the data and then we want the sum of that distinct data.

rahulkushwaha

One of the best YouTube channels for engineering and computer science students.👌👌

hammadaftab

Thank you so much for all your hard work!!! We really appreciate it!!

SahirJafri

select sum(distinct(salary) )from emp; will actually give sum of distinct salaries.

ankitashahane

select count(distinct(dept)) from emp;

This is the correct one thanks

jameskamgar

Sir you deserve to be a best youtuber according to me you explaining topic very easily

varunsonavne

It was a great video to learn SQL, But in this video kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee;

atulraj

7 lakh views only 20k likes...guys if you gain something from these videos don't br thats selfish do like for this man he is working hard for us...he will gain something from us if we do like and subscribe....

nikitapurohit

I got Alpha in OS by understanding concepts from videos of sir now I am studying DBMS and now I again came back to sir lectures

ghulammahdi

I watch all of your videos and you are a saviour! You make us understand complex concepts in easier way, thanks a ton! I recommend your channel to my friends and they love it too:)

deepikareddy

Great content, no doubt on that! !! but the only problem I usually face is that videos are not in sequence in playlist, in this playlist also after Lec -50 there is direct Lec-55 andI couldn't find Lec-51 in this playlist. This is the same reason I left in between the 'Computer Organization' series..

chaitanyahajare

Sir ji query thori glt likh di apne
Select COUNT(DISTINCT salary) from emp order by asc;

universeboss

i think correct syntax is -.> SELECT count (DISTINCT salary) FROM emp; thanks for videos sir

kp_nagar

You are a great teacher...much appreciated...thanks...no technical background required to understand your explanation..

shrikant

i really appreciate ur videos. They helped me alot in clearing my concepts thanks for such good stuff

merafunpoint

One question but the answer providing with complete details, that's superb. Thank you so much sir

athukutti

Lec-67: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS

Lec-67: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS

Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)

Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

|Course IS 2511| - |Oracle SQL | - Lab 07- Aggregate Functions and Group by - Part 1|

29 - | MS SQL Server For Beginners | - | Aggregate Functions | - |Summary Functions|

SQL | Windows Vs Aggregate Functions

SQL Aggregate vs Aggregate Window Functions

Master the SQL SELECT statement part 06: Aggregate Functions, GROUP BY and HAVING clauses

SQL Tutorial - 6 Intro to Aggregate Functions

SQL Tutorial: CASE WHEN with aggregate functions

DBMS - Aggregate Function in Relational Algebra

SQL Aggregates: COUNT(*) aggregate function

SQL Day 8: Aggregate Functions

Lec-113: How Aggregate Functions work on NULL Values | SQL | DBMS

SQL AGGREGATE FUNCTIONS || COUNT( ), SUM( ), AVG( ), MIN( ), MAX( ) || SQL COMMANDS || SQL || DBMS

Aggregate Functions, Group by Clause and Having Keyword in SQL ? | SQL Server Interview Questions

Aggregate Functions in SQL SERVER | COUNT(*) VS COUNT(DISTINCT)

SQL in Amharic Part18 – Aggregate Function, MAX, MIN, SUM, AVG, COUNT, LISTAGG, GROUP BY, HAVING

DMS - Aggregate Functions in SQL

99% of SQL Users Don't Know This AMAZING Function

SQL Analytics vs Aggregate function with Example for e.g. find Employees Count by Department.

Lec: 70 | Aggregate Functions | MIN(), MAX(), AVG(), SUM(), COUNT() | SQL | DBMS | Bangla Tutorial

SQL Aggregate Functions || DBMS

SQL Tutorial Part 7 | SQL Aggregate Functions | Group By Clause | 10 Important SQL Queries |