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

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 / swastik

1 Answers
3825 Views
I also Faced
E-Mail Answers

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

Answer / lokeshwari

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

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers Polaris,

what is innodb? : Sql dba

0 Answers

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers Wipro,

How do I delete a trigger?

0 Answers

write the Sql query for creating database backup?

7 Answers TCS,

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers

What is sql performance tuning?

0 Answers

what eliminate duplicate without using roenum and not

5 Answers Matrix,

Is json a nosql?