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
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
what are date and time intervals? : Sql dba
how to enter characters as hex numbers? : Sql dba
Why do we use set serveroutput on?
What is difference between stored procedures and application procedures?
What is memory optimized table?
what is recursive stored procedure? : Sql dba
explain the difference between bool, tinyint and bit. : Sql dba
How can we find duplicate records in a table?
What are the types pl/sql code blocks?
What is a pragma statement?
How to check if a column is nullable before setting to nullable?
What are tuples in sql?
What is a data definition language?
what are all the different types of indexes? : Sql dba