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

Write a query to find the names of users that begin with "um" in sql?

922

What does 0 mean in sql?

910

what are the different index configurations a table can have? : Sql dba

933

What is trigger in flip flop?

955

What does count (*) do in sql?

951

Why we use sql profiler?

907

Are views faster than queries?

915

How can a function retun more than one value in oracle with proper example?

1025

how do you control the max size of a heap table? : Sql dba

918

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

904

Why do we need sharding?

934

how do you login to mysql using unix shell? : Sql dba

1014

what is row? : Sql dba

1162

What is sap sql?

924

How to run sql*plus commands in sql developer?

1083