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
What is identity column in sql server?
What is the difference between left outer join and left join?
Is inner join same as self join?
What are the various levels of constraints?
What are functions in sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
what are set operators in sql? : Sql dba
Is a view faster than a stored procedure?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is an exception in PL/SQL? What are the two types of exceptions?
What are reports usually used for?
What are the different types of functions in sql?
What is your daily office routine?
what is index? : Sql dba
Is truncate ddl or dml?