select c1 as c1 from t1 union select c2 as c1 from t1; try this one.

----> There is a table T with two columns C1 and C2.
The data is as below:
C1 C2
1 4
2 5
3 6

Question Posted / ramaraju

Answer Posted / ramaraju

select c1 as c1 from t1
union
select c2 as c1 from t1;

try this one.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to run pl sql program in mysql?

1031

What is clustered index in sql?

1065

Explain the advantages and disadvantages of stored procedure?

1159

What does bitemporal mean?

1080

How do I count duplicates in sql?

1122

Differentiate between sga and pga.

1176

What packages(if any) has oracle provided for use by developers?

5827

What is raid? How does it help storage of databases?

1095

Why commit is not used in triggers?

1051

How can we make an if statement within a select statement?

1026

What is asqueryable?

988

what are null values? : Sql dba

968

What is sql in java?

1096

What are the disadvantages of not performing database normalization?

1177

What are hotfixes and patches?

961