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

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

760

What is a unique constraint?

803

What is join view in sql?

696

What is compute?

728

What is an exception in PL/SQL? What are the two types of exceptions?

845

What is sql exception?

703

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1916

what is a foreign key ? : Sql dba

782

Is clustered index a primary key?

687

How do you exit in sql?

815

What is record data type?

677

What are the types of records?

737

what does the t-sql command ident_current does? : Transact sql

732

what is view? : Sql dba

726

Is oracle sql free?

726