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

What is use of term?

625

differentiate between float and double. : Sql dba

561

what is a trigger in mysql? : Sql dba

603

What is substitution variable in pl sql?

505

Is it possible to link two groups inside a cross products after the cross products group has been created?

596

What is record variable?

553

What is oracle pl sql developer?

532

Can you have more than one trigger on a table?

532

Can we use threading in pl/sql?

521

what is log shipping? : Sql dba

613

What are the features of pl sql?

563

What are hotfixes and patches?

529

What is sqlite used for?

532

What does subquery mean in sql?

542

What does the acronym acid stand for in database management?

543