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

How do I start sql from command line?

1081

What are the query optimization techniques?

1000

What is mutating table error?

1240

What does partition by mean in sql?

1031

How to use boolean type in select statement?

1139

Why is sql important?

1171

What is pl/sql table? Why is it used?

1092

What is the syntax and use of the coalesce function?

1214

is it possible to pass an object or table to a procedure as an argument?

1178

Does view store data in sql?

1042

What is on delete set null?

1136

What are the different types of functions in sql?

1099

What are the advantages of pl sql over sql?

1074

What is a left join?

1007

give the syntax of grant and revoke commands? : Sql dba

1218