select id,decode(id,'1','3','3','1'

if table named a is there
and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

Question Posted / lokeshwari

Answer Posted / lokeshwari

select id,decode(id,'1','3','3','1','2','4','4','2') from tb11;

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many commands are in sql?

1123

What is trigger types of trigger?

1144

Is truncate ddl or dml?

1038

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1053

What are types of indexes in sql?

1139

Can one improve the performance of sql*loader? : aql loader

1099

How much does sql cost?

1069

What is sap sql anywhere?

1171

How do you update a sql procedure?

1092

What information is needed to connect sql*plus an oracle server?

1080

What is string join?

1028

What is number function in sql?

1018

Which is the correct statement about truncate and delete?

1174

What is the purpose of the partition table?

1092

What are the events on which a database trigger can be based?

1247