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 'mysqladmin' in mysql? : Sql dba
What is out parameter used for eventhough return statement can also be used in pl/sql?
How is debugging done?
who introduced sql?
How do I truncate a sql log file?
How do you respond to dementia behavior?
What is difference between inner join and cross join?
What is user in sql?
Is not null in sql?
What is partition in sql query?
what is row? : Sql dba
How bulk collect improves performance?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Explain autonomous transaction.
Enlist the characteristics of pl/sql?