what will be the output:
select 1 from emp
union all
select 2 from emp;
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 is snowflake sql?
What is use of trigger?
What type of database is sql?
How do I partition in sql?
What is oracle and pl sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
How can I make sql query run faster?
What is sqlexception in java?
What is scalar data type in pl sql?
How to read xml file in oracle pl sql?
How do you truncate?
What language is oracle sql developer?
Explain constraints in sql?
How bulk collect improves performance?
How to write pl sql program in mysql command prompt?