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 to dump a table to a file with 'mysqldump'? : Sql dba
what is normalization? : Sql dba
Is sql a case sensitive language?
What is where clause in sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is cartesian join in sql?
what is the use of friend function? : Sql dba
How to handle bulk data?
Which function is used to return remainder in a division operator in sql?
What is difference between mysql and postgresql?
What is a left inner join?
What is left join in sql?
Can we insert data in view?
what is a join? : Sql dba
What is pl sql collection?