what is the output of this query selet * from employee
where 1=2 ??
Answer Posted / priyanka agarwal
It will return 0 rows as 1 will never be ewual to 2
| Is This Answer Correct ? | 50 Yes | 2 No |
Post New Answer View All Answers
What are all ddl commands?
How to fix oracle error ora-00942: table or view does not exist
What is pl sql script?
How many triggers can be applied to a table?
How do you truncate?
Write a sql query to convert all character to uppercase after hypen.
Are subqueries faster than joins?
how would you get the current date in mysql? : Sql dba
What are the subsets of sql?
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
Can we group by two columns in sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
How can a pl sql block be executed?
How can a function retun more than one value in oracle with proper example?
what is innodb? : Sql dba