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 do you optimize a stored procedure query?

998

what are date and time data types? : Sql dba

984

How do you remove duplicates without using distinct in sql?

977

Can primary key be changed?

906

explain access control lists. : Sql dba

1002

Is it possible to create startup or shutdown trigger for on-schema?

1029

What is data control language (dcl)?

1138

What is an invalid partition table?

1025

What are some emotional triggers?

985

Does sql between include endpoints?

1015

Explain raise_application_error.

1098

What is the maximum rows in csv?

923

What are types of indexes in sql?

1082

How to get each name only once from an employee table?

1116

How can check sql version from command line?

1088