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.
View Answer Bookmark Now

How would you calculate 13 * 15 in SQL ?
View Answer Bookmark Now
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.
View Answer Bookmark Now
While using SQL pattern matching, what is the difference between '_' (underscore) and '%' wildcard symbols ?
View Answer Bookmark Now

Informatics Practices

Is NULL value the same as 0 (zero) ? Write the reason for your answer.

SQL Queries

Answer

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 ?