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

Advertise your Business Here

Refer this Site

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Databases >> SQL PLSQL

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

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

Question Submitted By :: Lmeher.tcs

I also faced this Question!!

Rank

Answer Posted By

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

Answer
# 1

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 ?

15 Yes

6 No

M.m

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

Answer
# 2

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

3 No

Ankush

Question	Asked @	Answers
Other SQL PLSQL Interview Questions


what is self join and how it works??	infosys	2
What are different types of refreshment techniques of materialised view		2
write a query to delete similar records in different tables with same structure		4
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.	CGI	5
what is variable in package specification		2
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?		2
How to get second highest salary from a table		3
i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w	Scope-International	4
how to create table with in the procedure or function?	Genpact	2
Two Methods of retrieving SQL?	Microsoft	6
Delete the emps whose salaries are lowest sals of their own dept.		5
How can analyze query after generating explain plan ?	Thermotech	2

For more SQL PLSQL Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2012 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com