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
- 13294 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 |
What is auto increment feature in sql?
What is materialized view. What are different methods of refresh?
What is the use of count (*) in sql?
What are the different types of functions in sql?
What is structural independence and why is it important?
What is pl sql collection?
define join and explain different type of joins? : Sql dba
Can we have exception part in trigger ?
Is natural join same as inner join?
What is a bitmap index?
4 Answers Choice Solutions, Infosys,
how to use regular expression in pattern match conditions? : Sql dba
What is t-sql? : Transact sql
-
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)
