what is the output of this query selet * from employee
where 1=2 ??
Answers were Sorted based on User's Feedback
Answer / priyanka agarwal
It will return 0 rows as 1 will never be ewual to 2
Is This Answer Correct ? | 50 Yes | 2 No |
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 |
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 |
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 |
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 |
Answer / rakesh anand
In Oracle Database 10g Express Edition
it shows "no data found"
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bhagyashree
it will return those query whose value will be 2 in first
column
Is This Answer Correct ? | 0 Yes | 7 No |
What is a native sql query?
What is thread join () in threading?
Explain raise_application_error.
Can we use loop in sql?
What is identity column in sql server?
What is replication id?
What does (*) mean in sql?
What are dml commands?
How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
12 Answers IBM, TCS, UHD,
What is the differnce between view and materialized view
How do I create a sql script?
What is pl sql script?