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
- 13293 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
What are pl/sql cursors?
When is a declare statement required?
What are all ddl commands?
What are the popular database management systems in the it industry?
How does an execution block start and end in pl sql?
what is column? : Sql dba
How to run sql statements through the web interface?
What are the disadvantages of not performing database normalization?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is the usage of the distinct keyword?
What is a sql statement?
What is data control language?
What are the usages of sql?
What is sqlca in powerbuilder?
When are we going to use truncate and delete?
