select new_no as new_noz from t01 union select old_no as new

table -
new_no old_no
2345 1234
3456 2345
5678 4567

output sud be -new_no
1234
2345
3456
4567
5678

Question Posted / bibhu

Answer Posted / bibhu

select new_no as new_noz
from t01
union
select old_no as new_noz
from t01
order by new_noz

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does desc stand for?

1037

What is AUTH_ID and AUTH_USER in pl/sql ?

2155

Why do we use procedures in sql?

1044

how to analyze tables with 'mysqlcheck'? : Sql dba

975

How to make a copy values from one column to another in sql?

1003

Can we change the table name in sql?

907

How to read xml file in oracle pl sql?

875

How do you write an inner join query?

914

What is sequence in sql?

967

what is an extent ? : Sql dba

1043

What is sql and db2?

960

Why do we use %rowtype & %type in plsql?

1006

difference between anonymous blocks and sub-programs.

1097

What is auto increment feature in sql?

1082

How to get unique records from a table?

919