what will be the output:
select 1 from emp
union all
select 2 from emp;
- 2 Answers
- 12688 Views
- iNautix, I also Faced
- E-Mail Answers
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
Can we use rowid as primary key?
What is procedure and function?
Why does sql need a server?
Where is sql database stored?
What is the use of <> sql?
describe transaction-safe table types in mysql : sql dba
Is join same as left join?
What are the set operators in sql?
What is sql not null constraint?
Can sql function call stored procedure?
What are primary key and foreign key and how they work?
What is the usage of nvl function?
How can one get sql*loader to commit only at the end of the load file? : aql loader
How to display Row Number with Records in Oracle SQL Plus?
Why having clause is used in sql?
