TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Output When We Write Null = Null in Where Clause
Pramod Thakur
Jan 16, 2016
3.7
k
0
0
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
In this blog you will learn What is output when we write null = null in where clause.
In this blog we see the output of following query.
Query 1: Select * from sysobjects where null is null
Output
It return the total number of records of sysobjects.
Query 2: Select * from sysobjects where null = null
Output
It return 0 records of sysobjects.
Query 3: Select * from sysobjects where isnull(null,'')=''
Output
It returns the total number of records of sysobjects. The output of query1 and query3 is same.
I hope this is useful.
Next Recommended Reading
Display Zero Instead of Null in Dynamic Pivot in SQL Server