what will be the output: select 1 from emp union all select 2 from emp;

what will be the output:
select 1 from emp
union all
select 2 from emp;

Question Posted / lmeher.tcs

2 Answers
12316 Views
iNautix, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what will be the output: select 1 from emp union all select 2 from emp;..

Answer / m.m

1 will be printed as many times as the number of rows in
emp table
followed by 2 begin printed as many times as the number of
rows in emp table
OP:
1
----------
1
1
1
1
1
1
1
1
1
1
1

1
----------
1
1
1
2
2
2
2
2
2
2
2

1
----------
2
2
2
2
2
2

28 rows selected.

Is This Answer Correct ?

22 Yes

6 No

what will be the output: select 1 from emp union all select 2 from emp;..

Answer / 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