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

What is trigger explain it?

636


Should I use mbr or gpt?

631


How can I see all tables in sql?

639


What are the qualities of 2nf?

644


What are the different types of triggers?

672






What are properties of the transaction?

637


what are numeric data types? : Sql dba

669


What is the syntax and use of the coalesce function?

711


Is pl sql useful?

635


What is sorting in sql?

598


how can we find the number of rows in a table using mysql? : Sql dba

682


What is pivot in sql?

590


How subquery works in sql?

629


What are joins in sql?

625


what is the difference between a having clause and a where clause? : Sql dba

591