Interested to Buy Any Domain ? << Click Here >> for more details...
what will be the output:
select 1 from emp
union all
select 2 from emp;
- 2 Answers
- 13333 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How we can update the view?
Can we insert delete data in view?
Why do we need a foreign key?
Explain sql data types?
What is the difference between sql, mysql and sql server?
What is pragma in sql?
What is sql*loader?
Explain scalar functions in sql?
How do you run a query?
How does a covering index work?
What is the non-clustered index in sql?
What are the types of views in sql?
How many tables can a sql database have?
How to use boolean type in select statement?
What are the types of sql commands?
