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
- 13292 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are the properties and different types of sub-queries? : Sql dba
Can a composite key be null?
How to select all records from the table?
Show how functions and procedures are called in a pl/sql block.
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How much does a sql dba make? : SQL DBA
Can we perform dml on view?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Explain the working of foreign key?
What is a database trigger?
What is the difference between a query and a report?
What is clause in sql?
What is basic structure of pl sql?
What is database sql?
Can we create view in stored procedure?
