Difference between Null and 0 in sql

Hello

There are some difference i listed below :

1 . Null :

- Null value means value is empty or in some case may be unknown

- There is no value will be assigned till now when we use either variable or anything else

- You can assign null value , without worrieing it's datatype

- In other words you can say null value acts as a "placeholder"

2 . 0 Value :

- 0 Itself is a numeric value that means a lot than null value

- Zero itself is value that has meanin , and shows count of zero

- Most importantly plays important part in mathematics equations

- When we provide value = 0 to anything , than it stored in memory for reference and will be used further for other operations

That's what all i can say about that

But still you want more reference you can follow :

https://stackoverflow.com/questions/16840522/replacing-null-with-0-in-a-sql-server-query

https://softwareengineering.stackexchange.com/questions/134861/how-can-i-explain-the-difference-between-null-and-zero

https://stackoverflow.com/questions/24444518/difference-between-null-and-blank-value-in-mysql

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manav Pandya8y ago
Accepted answer
Hello

There are some difference i listed below :

1 . Null :

- Null value means value is empty or in some case may be unknown

- There is no value will be assigned till now when we use either variable or anything else

- You can assign null value , without worrieing it's datatype
- In other words you can say null value acts as a "placeholder"

2 . 0 Value :

- 0 Itself is a numeric value that means a lot than null value

- Zero itself is value that has meanin , and shows count of zero

- Most importantly plays important part in mathematics equations

- When we provide value = 0 to anything , than it stored in memory for reference and will be used further for other operations

That's what all i can say about that

But still you want more reference you can follow :

https://stackoverflow.com/questions/16840522/replacing-null-with-0-in-a-sql-server-query

https://softwareengineering.stackexchange.com/questions/134861/how-can-i-explain-the-difference-between-null-and-zero

https://stackoverflow.com/questions/24444518/difference-between-null-and-blank-value-in-mysql

Thanks
+1
Ranjit Powar8y ago
Null means nothing and 0 is integer value. You can use of in arithmetic operation but not null. Null represents that there is no value
0