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
- 13440 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 the use of function in sql?
What is the difference among union, minus and intersect?
What is trigger in flip flop?
Query for second maximum salary in each in each department
15 Answers DST Global Solutions, TCS,
what is single byte over head in oracle..?
what is a trigger in mysql? Define different types of trigger. : Sql dba
explain what is mysql? : Sql dba
What is the difference between count 1 and count (*) in a sql query?
What is primary key sql?
what are the advantages of cursors than procedures?
What are the datatypes a available in PL/SQL ?
What is memory optimized table?
-
Oracle (3253) - 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)
