It will return 0 rows....since condition in where clause will fail as 1 i

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

Question Posted / rohan mhatre

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

Please Help Members By Posting Answers For Below Questions

Why we use triggers in mysql?

992

what are the features and advantages of object-oriented programming? : Sql dba

1006

What are the disadvantages of file system?

1267

explain mysql aggregate functions. : Sql dba

986

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1107

What are all the different types of indexes?

1147

Explain what is dbms?

1060

Can a varchar be a primary key?

1009

what is bdb (berkeleydb)? : Sql dba

1034

How many clustered indexes can be created on a table?

1075

Can we write ddl statements in functions?

1116

what is datawarehouse? : Sql dba

1015

What is multiple columns?

1065

What are two statement types in sql?

1100

how many tables will create when we create table, what are they? : Sql dba

1073