what will be the output:
select 1 from emp
union all
select 2 from emp;
Answer Posted / ankush
it returns the number 1 same number columns as well as
union with the value 2 again with the same number of
columns the table emp have.
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What is sql profiling in oracle?
What does select count (*) mean in sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is a system versioned table?
How do you declare a variable in pl sql?
What is coalesce sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is ttitle and btitle?
explain primary keys and auto increment fields in mysql : sql dba
What is the difference between null value, zero, and blank space?
Does user triggers have entry for trigger with compilation errors?
what is sql? : Sql dba
Name the operator which is used in the query for pattern matching?
What is replication id?