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
- 13334 Views
- iNautix, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ankush
it returns the number 1 same number columns as well as
union with the value 2 again with the same number of
columns the table emp have.
| Is This Answer Correct ? | 0 Yes | 6 No |
Why do we use function in pl sql?
What are tables in sql?
Is sql open source?
What is the purpose of the partition table?
how to include character strings in sql statements? : Sql dba
What is a delimiter in sas?
what is bcp? When does it used? : Sql dba
Does inner join return duplicate rows?
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
Why does %isopen return false for an implicit cursor?
How to Declare Fixed Length String Value In PL SQL
Is a foreign key always unique?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
