Informatics Practices
Is NULL value the same as 0 (zero) ? Write the reason for your answer.
SQL Queries
2 Likes
Answer
No, a NULL value is not the same as 0 (zero) in SQL. In SQL, NULL represents a missing or unknown value and is a legal empty value. On the other hand, 0 is a specific numeric value representing the number zero.
Answered By
1 Like
Related Questions
What is a datatype ? Name some data types available in MySQL.
How would you calculate 13 * 15 in SQL ?
Write the UPDATE command to increase the commission (Column name : COMM) by 500 of all the Salesmen who have achieved Sales (Column name : SALES) more than 200000. The table's name is COMPANY.
While using SQL pattern matching, what is the difference between '_' (underscore) and '%' wildcard symbols ?