ru compare the 2 null values?
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 |
What is latest version of mysql?
What are MySQL transactions?
What is mysql connector used for?
What different Stored Objects are supported in MySQL?
Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
Which is faster mysql or mongodb?
How do I start mysql in mysql workbench?
What is mysql database used for?
How to show certain selected rows with the value "pcds".
What happens if a table has one column defined as TIMESTAMP?
What is int unsigned?
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)