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 the use of desc in sql?
How to select all records from the table?
how to include character strings in sql statements? : Sql dba
How can I see all tables in sql?
what does the t-sql command ident_current does? : Transact sql
Explain the commit statement.
How can we make an if statement within a select statement?
State some properties of relational databases?
What is the use of procedures?
Are sql connections encrypted?
Can you call pl/sql package functions from within a fast formula?
What are the differences between in and exists clause?
What is sql stand for?
How do I get sql certification?
What does fetching a cursor do?