table -
new_no old_no
2345 1234
3456 2345
5678 4567
output sud be -new_no
1234
2345
3456
4567
5678
Answers were Sorted based on User's Feedback
Answer / 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 |
How can I delete duplicate rows?
how many tables will create when we create table, what are they? : Sql dba
Name some usages of database trigger?
How do I run sql profiler?
select 10 from dual; y its showing all the rows with 10?
What is an Exception ? What are types of Exception ?
what are the advantages of package?
Is sql considered coding?
select sal from emp group by sal
display null value rows with out using null function?
what is uncommittable transactions? : Transact sql
what is meant by databases