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 the command used to fetch first 5 characters of the string? : Sql dba
What is scalar function in sql?
What is pl sql in dbms?
how to convert numeric values to character strings? : Sql dba
What is nosql example?
what is meant by nl2br()? : Sql dba
How many types of keys are there in sql?
How do I view a procedure in sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
what is text? : Sql dba
How do you know if a relationship is 2nf?
Write a sql query to convert all character to uppercase after hypen.
What is the purpose of cursors in pl/sql?
What are the different datatypes available in PL/SQL?
What is the least restrictive isolation level? : Transact sql