filmov
tv
Lec-113: How Aggregate Functions work on NULL Values | SQL | DBMS
Показать описание
If an aggregate function against a column that contains nulls is executed, the function ignores the nulls. This prevents unknown or inapplicable values from affecting the result of the aggregate.
CODE:
Step1: Create table t1 ( A int, B int);
Step2: Insert into t1 values(1,null);
Insert into t1 values(2,null);
Insert into t1 values(3, null);
Insert into t1 values(4,null);
Insert into t1 values(null,null);
Step3: Select count(*) from t1;
Select count(A) from t1;
Select count(B) from t1;
►Database Management System(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:
►Structured Query Language (SQL):
►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:
0:07:23
Lec-113: How Aggregate Functions work on NULL Values | SQL | DBMS
0:00:47
Aggregate Functions in SQL #sql #shorts
0:08:10
Mastering Aggregate Functions in SQL: Calculating MIN, MAX, AVG, SUM, and COUNT
0:08:29
SQL Aggregate Functions
0:10:03
SQL Aggregate Functions
0:13:58
Lec-112: View in Database | Oracle, SQL Server Views | Types of Views
0:03:04
The TRUTH about Aggregate functions and NULL values! #sql
0:06:16
SQL Crash Course for Absolute Beginners - Part 7 | Aggregate Function (Nepali)
0:04:00
Aggregate functions in SQL | SQL Tutorial For Beginners
0:00:46
SQL Aggregates: COUNT(*) aggregate function | Part 19
0:18:46
Unit - 9 - Lecture 7 Date Time and Aggregate Function
0:01:00
#Aggrigate function in non aggregate Query. #sql part 1
0:00:56
What is an Aggregate Function in SQL?
0:01:11
SQL : Selecting column names where values are NULL
0:08:10
Aggregate Functions in SQL | Group By and Having Clause in SQL
0:20:02
Analytical Vs. Aggregate Functions: What's the Difference? Oracle SQL Tricky Interview Quest...
0:00:55
What is the difference between Aggregate Functions and Individual Row Functions? #cbse #term2 #sql
0:04:36
#sql How to handle NULL while aggregation | SUM() | AVG() | Data Analyst | Data Engineer |Math calc
0:07:57
Lec-129: Simple vs Complex vs Materialized Views with examples | DBMS
0:05:14
SQL7 - Aggregate functions; aggregate and NULLs; using NVL
0:00:50
##Aggregate Function#excel#shortsvideo #shorts
0:16:12
Aggregate Functions In SQL | COUNT, SUM, AVG, MIN, MAX | IFNULL( )
0:00:14
Cant aggregate Null column #TableauRage #tableau
0:02:49
group by clause without aggregate function
Комментарии