Interested to Buy Any Domain ? << Click Here >> for more details...
ru compare the 2 null values?
- 2 Answers
- 5795 Views
- ACC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prathiba
U can compare the two null values, by using these operators
IS NULL: operator returns true of column value is NULL.
IS NOT NULL: operator returns true of column value is not
NULL.
<=> operator compare values, which (unlike the = operator)
is true even for two NULL values
| Is This Answer Correct ? | 2 Yes | 1 No |
IMPOSSIBLE...!!!!
WE CAN'T COMPARE TWO NULL VALUES
COZ NULL MEANS "THE VALUE IS UNKNOWN";
SO WE CANT COMPARE THE UNKNOWN VALUES....
| Is This Answer Correct ? | 0 Yes | 0 No |
How does triggers work in mysql?
What's the latest version of mysql?
What is a tinyint in mysql?
How do I find users in mysql?
How to calculate the difference between two dates?
What are the advantages of MySQL when compared with Oracle?
Is mysql from oracle?
How to delete the repeated records from a table?
How to change the database engine in mysql?
What is a definer?
How to delete an existing column in a table?
Does adding an index lock a table?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
