adspace


table -
new_no old_no
2345 1234
3456 2345
5678 4567

output sud be -new_no
1234
2345
3456
4567
5678

Answer Posted / lizamishra15

pls send me th answer

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

1029


what are aggregate and scalar functions? : Sql dba

1145


Can we use distinct and group by together?

1149


how to escape special characters in sql statements? : Sql dba

1127


Do we need to rebuild index after truncate?

1156


If a cursor is open, how can we find in a pl/sql block?

1253


Is inner join faster than left join?

1289


What is the current version of postgresql?

1191


define sql insert statement ? : Sql dba

1111


How do I remove duplicates in two columns?

1208


Is primary key always clustered index?

1102


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2103


What is the best sql course?

1065


how to start mysql server? : Sql dba

1280


what is bcp? When does it used? : Sql dba

1066