what is the output of this query selet * from employee
where 1=2 ??
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of database management systems?
Why schema is used in sql?
Is a view faster than a stored procedure?
What is a ddl command?
Is it possible to read/write files to-and-from PL/SQL?
What is the difference between database trigger and stored procedure?
How do you determine the current isolation level? : Transact sql
How do I truncate a sql log file?
What is a Mapplet?
what are the join types in tsql? : Transact sql
how to delete an existing column in a table? : Sql dba
State few characteristics of pl/sql?
Why is theta join required?
What plvcmt and plvrb does in pl/sql?
What is a primary key example?