1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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


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 is the order of sql select?

0 Answers  

What are the syntax and use of the coalesce function?

0 Answers  

Explain aggregate functions are available there in sql?

0 Answers  

How to display the current date in sql?

0 Answers  

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,




what is a foreign key ? : Sql dba

0 Answers  

What is query optimization in sql?

0 Answers  

Which is faster joins or subqueries?

0 Answers  

Write a simple program on cursors

2 Answers   BirlaSoft,

What is delimiter sql?

0 Answers  

what are enums used for in mysql? : Sql dba

0 Answers  

Does execute immediate commit?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories