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
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
No comments:
Post a Comment