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
- 13435 Views
- iNautix, I also Faced
- E-Mail Answers
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
Does execute immediate commit?
What is thread join () in threading?
What is a left inner join?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What is count * in sql?
What does over partition by mean in sql?
What is the purpose of primary key?
how to see the create table statement of an existing table? : Sql dba
Which is better join or inner query?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Is sql a dbms?
What are the types of index in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What are the ddl commands?
what is auto increment? : Sql dba
