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

What is basic structure of pl sql?

1131

What is mutating table error?

1240

How is debugging done?

1020

Can we create index on primary key?

1020

Explain the working of foreign key?

1136

How to run sql commands in sql*plus?

1255

What is difference between procedure and trigger?

1022

How sql query is executed?

1187

who introduced sql?

1074

What is the difference between a subquery and a join?

1173

What is pivot table in sql?

1171

Can we insert delete data in view?

1002

Define tables and fields in a database

1181

how to create a test table in your mysql server? : Sql dba

1057

Is natural join and inner join same?

993