Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output of this query selet * from employee
where 1=2 ??
- 11 Answers
- 18814 Views
- I also Faced
- E-Mail Answers
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
how can you create an empty table from an existing table? : Sql dba
How do you delete duplicates in sql query using rowid?
what is timestamp in mysql? : Sql dba
What is the difference between a database and a relational database?
What is the use of %rowtype?
What is mutating error in pl sql?
Why do we use triggers?
Is a foreign key always unique?
Why use triggers in sql?
How do I clear the screen in sql plus?
What is sql mysql pl sql oracle?
How do I tune a sql query?
Is left join inner or outer by default?
What is the difference between local and global temporary table?
What is a primary key sql?
