what is the output of this query selet * from employee
where 1=2 ??

Answer Posted / rohan mhatre

It will return 0 rows....since condition in where clause
will fail as 1 is not equal to 2

Is This Answer Correct ?    18 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to escape special characters in sql statements? : Sql dba

504


Is sql low level language?

571


What is the sql*loader? : aql loader

585


What are database links used for?

588


How to move files from one directory to another in pl sql?

636






How many primary keys can a table have?

526


What does pl sql developer do?

504


Why do we create views in sql?

547


What is a recursive stored procedure?

612


What are different types of keys?

517


how many sql ddl commands are supported by 'mysql'? : Sql dba

518


When are we going to use truncate and delete?

548


what is the use of double ampersand (&&) in sql queries?

619


Explain the update statement in sql

556


discuss about myisam index statistics collection. : Sql dba

521