what is the output of this query selet * from employee
where 1=2 ??
Answer Posted / ashokkumar
create table temp_employee as select * from employee where 1=2;
this is only for a correct answer..
it is create from a temporary table in same table name.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we enter data in a table in design view?
What do you understand by case manipulation functions?
Can triggers stop a dml statement from executing on a table?
Can we use joins in subquery?
What is the left table in sql?
How is indexing done in search engines?
What is the need of a partition key?
What is dcl in sql?
How do you exit in sql?
What is the life of an sql statement?
What is foreign key sql?
Why do we need cursor in pl sql?
what is difference between delete and truncate commands? : Sql dba
Determine if oracle date is on a weekend?
can sql servers linked to other servers like oracle? : Sql dba