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
What is oracle sql developer?
Where do we use pl sql?
Is a view faster than a stored procedure?
how to see the create table statement of an existing table? : Sql dba
Why should I use postgresql?
Is sql developer case sensitive?
what are the advantages of using stored procedures? : Sql dba
How do you modify a table in sql?
What is a parameter query?
How to read xml file in oracle pl sql?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
how to use 'mysql' to run sql statements? : Sql dba
Can function return multiple values in sql?
Can you skip header records while loading? : aql loader
What is the use of count (*) in sql?