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

Is crud a cuss word?

971

how to use like conditions? : Sql dba

1036

What is pl sql script?

975

what is a database? : Sql dba

1097

How does postgresql compare to oracle/db2/ms sql server/informix?

980

Why are aggregate functions called so?

896

Does sqlite need a server?

992

what are the differences between char and varchar? : Sql dba

1000

Does a primary key have to be a number?

915

Can we create table in function?

907

What is the left table in sql?

911

Enlist the advantages of sql.

937

Which table is left in left join?

951

List out the acid properties and explain?

903

Can we write ddl statements in functions?

1048