Difference between Null and 0 in sql

Question

What is the difference between null and 0 in sql?

Manav Pandya · 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

Ranjit Powar · Answer

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

Difference between Null and 0 in sql

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)