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


Please Help Members By Posting Answers For Below Questions

Can we enter data in a table in design view?

514


What do you understand by case manipulation functions?

539


Can triggers stop a dml statement from executing on a table?

614


Can we use joins in subquery?

531


What is the left table in sql?

515






How is indexing done in search engines?

527


What is the need of a partition key?

530


What is dcl in sql?

524


How do you exit in sql?

585


What is the life of an sql statement?

519


What is foreign key sql?

548


Why do we need cursor in pl sql?

643


what is difference between delete and truncate commands? : Sql dba

570


Determine if oracle date is on a weekend?

551


can sql servers linked to other servers like oracle? : Sql dba

548