say table1 has col1 & table2 has col1 column select col1 from table1

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 / alka

Answer Posted / alka

say table1 has col1 & table2 has col1 column

select col1 from table1
union
select col2 from table2

Is This Answer Correct ?

8 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How many categories of functions based their return modes?

1063

What is the use of keyword with encryption.

972

What is DCL?

978

How do I start and stop sql server?

967

how can you attach more than 20 ldf files in sql server

1949

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1063

Tell me what is fill factor?

907

What are the advantages of using cte?

952

What is lookup override?

964

How to create a dml trigger using create trigger statements?

977

List the advantages of using stored procedures?

999

Why use stored procedures in sql server?

958

What do you mean by subquery?

1024

What is row-level compre?

944

‘Order by’ is not allowed in a view how can you sort information from a view?

1028