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
Is nosql faster than sql?
What is posting?
How many types of index are there?
how are mysql timestamps seen to a user? : Sql dba
What is sql keyword?
What is the difference between in and between in sql?
How do you drop a trigger?
Which one is better sql or oracle?
how to get a list of columns in an existing table? : Sql dba
How can we implement rollback or commit statement in a trigger?
What is dense_rank in sql?
What is vector point function?
Is sql scripting language?
How do I make my sql query run faster?
what is commit? : Sql dba