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
- 18407 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
What is nosql db?
How many commands are in sql?
Does a join table need a primary key?
What is lexical units in pl sql?
What is the purpose of design view?
What is update query?
what are date and time data types? : Sql dba
What is partition in sql query?
What are the different set operators available in sql?
What is where clause in sql?
what is auto increment? : Sql dba
Can we use having without group by in sql?
Write the alter statement to enable all the triggers on the t.students table.
What will you get by the cursor attribute sql%found?
What is output spooling in sql*plus?
