Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Thursday, 9 June 2016

What is the output WHERE NULL=NULL? & Difference Between Count(*) and Count(Column Name) in Select Statement?

What is the output when SELECT statement with WHERE NULL=NULL?

EMPTY string

What is difference Between Count(*) and Count(Column Name) in Select Statement?

Count(*) will give Total Rows Even it Counts Duplicates and Null Values

But Count(Column) will not Count Null Values also count Duplicates.



When We need to select Null value where Column=NULL will give empty string

When you need to select Where Column is NULL will give value