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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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

Question Posted / mreddy

11 Answers
18603 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / priyanka agarwal

It will return 0 rows as 1 will never be ewual to 2

Is This Answer Correct ?

50 Yes

2 No

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

Answer / narendradivvela

no rows selected

Is This Answer Correct ?

33 Yes

0 No

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

Answer / selvaraj v, anna university

In Oracle 10g :
---------------

no rows selected.

E.g:
----

SQL> SELECT * FROM job;

EMPNO JOBTITLE
--------- --------------------
1 Tester
2 Accountant
3 Developer
4 COder
5 Director
6 Mediator
7 Proffessor
8 Programmer
9 Developer

9 rows selected.

SQL> SELECT * FROM job WHERE 1=2;

no rows selected.

Is This Answer Correct ?

19 Yes

0 No

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

Answer / 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

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

Answer / julien

indeed it will return o rows, but the goal behind is to
create a new table t2 as select * from t1 where 1=2, where
just the structure of table t1 will be copied without
copying data from table t1.

Is This Answer Correct ?

14 Yes

0 No

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

Answer / ashokkumar

create table temp_employee as select * from employee where 1=2;
this is only for a correct answer..
it is create from a temporary table in same table name.

Is This Answer Correct ?

0 Yes

0 No

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

Answer / prabu t

Error report:
Unknown Command

Is This Answer Correct ?

0 Yes

0 No

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

Answer / rakesh anand

In Oracle Database 10g Express Edition
it shows "no data found"

Is This Answer Correct ?

0 Yes

0 No

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

Answer / chinnu

It will be displayed as NULL

Is This Answer Correct ?

0 Yes

6 No

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

Answer / bhagyashree

it will return those query whose value will be 2 in first
column

Is This Answer Correct ?

0 Yes

7 No

Post New Answer