Hi
What the below code does.
select * from tablename where null = null
Thanks
Loading
Hi
What the below code does.
select * from tablename where null = null
Thanks
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Vijay Pratap SinghPosted Apr 16, 2024, 11:57 AM
The query
SELECT * FROM tablename WHERE NULL = NULLwill not return any rows. This is because in SQL, comparing something to NULL using the equality operator (=) always yields false, even if both operands are NULL.Jaimin ShethiyaPosted Apr 16, 2024, 11:45 AM
Hello Ramco,
It will give the empty result set.