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
- 13188 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
Explain normalization and what are the advantages of it?
What is vector point function?
What is the source code of a program?
how to shutdown mysql server? : Sql dba
What is an emotional trigger?
Why we use cross join?
Explain the update statement in sql
What is the process of debugging?
How to read xml file in oracle pl sql?
What is trigger and how to use it in sql?
What is trigger point?
Explain commit, rollback and savepoint.
What is materialized view in sql?
Why triggers are used?
what are the t string functions available in tsql? : Transact sql
