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 version is sql?

549

Enlist the characteristics of pl/sql?

1235

what are the advantages and disadvantages of views in a database? : Sql dba

529

What will you get by the cursor attribute sql%notfound?

587

What is the use of index in hive?

546

What does truncate mean in sql?

532

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

498

What is dynamic query?

537

Is a view faster than a stored procedure?

542

how do you know the version of your mysql server? : Sql dba

503

Explain polymorphism in pl/sql.

635

What is lexical units in pl sql?

565

What is an inner join sql?

542

What is data modelling in sql?

519

What is the use of double ampersand (&&) in sql queries? Give an example

609