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 select top 1 do in sql?

1007

how would you get the current date in mysql? : Sql dba

915

Can a commit statement be executed as part of a trigger?

998

Which function is used to return remainder in a division operator in sql?

1076

Does google use sql?

914

How many sql databases can you have on one server?

1018

What is cursor and why it is required?

1108

Is it possible for a table to have more than one foreign key?

979

Can we edit a view in sql?

927

What is the usage of nvl function?

983

What are the rules to be applied to nulls whilst doing comparisons?

1274

What is pl sql architecture?

924

What is record in pl sql?

1011

How to handle bulk data?

1269

What are triggers and its uses?

1003