what will be the output:
select 1 from emp
union all
select 2 from emp;
- 2 Answers
- 12681 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 many groups of data types? : Sql dba
is it possible to pass an object or table to a procedure as an argument?
What is the starting oracle error number? What is meant by forward declaration in functions?
How to change the order of columns in Oracle SQL Plus ?
Does postgresql run on the cloud?
What is the most important ddl statements in sql are?
What are procedures used for?
What is the use of prepared statement?
How to look at the current sql*plus system settings?
Why we use cross join?
What is the difference between joins?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What are the benefits of triggers?
Can we use ddl commands in pl sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
