select * from table1 union select * from table2 -- Union will give dis

There is a table1 with records (1,2,3,4,5,6) and table2
with records (4,5,6,7,8,9).write a query so as to get the
result as 1,2,3,4,5,6,7,8,9

Question Posted / john

12 Answers
17793 Views
RBS, I also Faced
E-Mail Answers

Answer Posted / john

select * from table1
union
select * from table2

-- Union will give distinct value of both tables

Is This Answer Correct ?

38 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can i Relate Tables in SSIS

1081

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1063

What is shared lock?

901

What does ss stand for sexually?

1084

How to encrypt Strored Procedure in SQL SERVER?

1167

What programming language would you use to create embedded functions in ssrs?

184

Explain for xml explicit mode?

974

What is the use of stored procedure?

939

List some advantages and disadvantages of stored procedure?

1016

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1075

What are the types of normalization?

1031

What are the types of ssrs?

145

How would you go about developing a ssrs report?

167

How to handle error or exception in sql?

982

Is mysql the same as sql server?

984