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
- 18077 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 makes a good primary key?
Can we write ddl statements in functions?
What is the size of partition table?
Is drop table faster than truncate?
How many indexes can be created on a table in sql?
How do I count rows in sql?
how to calculate expressions with sql statements? : Sql dba
How many types of normalization are there?
What are the types of optimization?
Can we edit a view in sql?
What is a null value?
How to check if a column is nullable before setting to nullable?
What are the types of sql commands?
What are sql injection vulnerabilities?
How do you create a db file?
