Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new..

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

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new..

Answer / lizamishra15

pls send me th answer

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Differentiate between % rowtype and type record.

0 Answers  


Why schema is used in sql?

0 Answers  


What is the best free sql database?

0 Answers  


Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,


How to find string or key value using pl/sql code?

2 Answers   Ramco,






if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  


How many sql are there?

0 Answers  


How do you remove duplicate records from a table?

0 Answers  


What is cte?

0 Answers  


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

0 Answers  


what is datawarehouse? : Sql dba

0 Answers  


Is hadoop a nosql?

0 Answers  


Categories