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

Is trigger a stored procedure?

921

Can a varchar be a primary key?

993

Is oracle and sql same?

991

What is the difference between delete, truncate and drop command?

1126

What are sql data types?

998

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

978

What is the most restrictive isolation level? : Transact sql

1068

Which language is used in sql?

1040

What are the query optimization techniques?

913

How do I remove sql plus from windows 10?

1073

What is exception? What are the types of exceptions?

1060

Can you inner join the same table?

975

What is a table?

999

what happens if you no create privilege in a database? : Sql dba

981

how to concatenate two character strings? : Sql dba

1074