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 are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1041

What is the difference between sql, mysql and sql server?

1099

How can you tell the difference between an index and a view?

937

Write a sql query to convert all character to uppercase after hypen.

1436

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1229

what is the functionality of the function htmlentities? : Sql dba

951

The select into statement is most often used to create backup copies of tables or for archiving records?

1064

Is left join same as inner join?

1124

What is the difference between sql and t sql?

1033

how can you see all indexes defined for a table? : Sql dba

992

What are the ways on commenting in a pl/sql code?

1132

What is sql server and ase?

1020

What is pl sql in oracle?

1039

Does truncate release storage space?

1072

Advantages and disadvantages of stored procedure?

1120