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
- 18561 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is delete faster than truncate?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is raw datatype in sql?
How can the performance of a trigger be improved?
Which is faster count (*) or count 1?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is sqlcontext?
What are the different type of joins in sql?
what are wild cards used in database for pattern matching ? : Sql dba
Why join is faster than subquery?
How do I turn a list into a table?
What is record variable?
What is a native sql query?
Explain foreign key in sql?
what are rollup and cube in t-sql? : Transact sql
