what is the output of this query selet * from employee
where 1=2 ??
Answer Posted / julien
indeed it will return o rows, but the goal behind is to
create a new table t2 as select * from t1 where 1=2, where
just the structure of table t1 will be copied without
copying data from table t1.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
How do you write an inner join query?
List the different type of joins?
What is rownum?
Differentiate pl/sql and sql?
What is the usage of sql functions?
Is pl sql a scripting language?
How to sort the rows in sql.
What will you get by the cursor attribute sql%rowcount?
How to run pl/sql statements in sql*plus?
Is t sql a programming language?
Is microsoft sql free?
What is the source code of a program?
what are the types of join and explain each? : Sql dba
How can you load multi line records? : aql loader
What is raid? How does it help storage of databases?