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

When is a declare statement required?

1144

Can we join more than 2 tables in sql?

1024

how to enter characters as hex numbers? : Sql dba

1045

What is sql procedures and functions?

1012

Why stored procedures are faster than query?

1029

Can we use join in subquery?

1100

How we can update the view?

1052

What is localdb mssqllocaldb?

1070

How many types of tables are there?

952

What is rownum in sql?

1046

How does a covering index work?

969

Does sap use sql?

996

Is sql similar to python?

979

Is sql considered coding?

1050

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1071