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 would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1345

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1074

What are the different types of database management systems?

1003

What is consistency?

1130

What is keys and its types?

1076

what is the difference between a web-garden and a web-farm? : Sql dba

1081

What is difference between pls_integer and integer?

967

define sql delete statement ? : Sql dba

1024

What is a table in a database?

1047

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1045

What is scope and visibility in PL/SQL?

1205

What is graph sql?

996

How do you run a query?

995

What are string functions in sql?

1249

How to write pl sql program in mysql command prompt?

1102