it returns the number 1 same number columns as well as union with the v

what will be the output:
select 1 from emp
union all
select 2 from emp;

Question Posted / ankush

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

Please Help Members By Posting Answers For Below Questions

How can triggers be used for the table auditing?

1119

How to run sql statements with oracle sql developer?

1123

What are the types of sql commands?

1162

How many joins in sql?

1059

How much does a sql dba make? : SQL DBA

991

What are the sql commands?

1232

what are null values? : Sql dba

1014

What is application trigger?

1056

What are the two types of exceptions in pl/sql?

1093

What is the difference between count 1 and count (*) in a sql query?

1056

How do I add a primary key to a table?

1085

Explain architecture of sql server notification services?

1114

Can you do multiple joins in sql?

1120

Write a sql query to convert all character to uppercase after hypen.

1486

What is dml and ddl?

1011