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

What is the difference between truncate and drop statements?

1165

How many parts of a pl sql block are optional?

1101

How many triggers can be applied to a table?

1039

What is sql key?

972

what is a unique key ? : Sql dba

1077

What is $$ in sql?

973

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1042

What is mutating error?

951

Are null values same as that of zero or a blank space?

1006

How many clustered indexes can be created on a table?

1067

How do I find duplicates in two columns?

1130

How does rowid help in running a query faster?

1402

Explain correlated query work?

1040

What is dml with example?

1066

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

976