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
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 |
Post New Answer View All Answers
What is the difference between local variables and global variables?
How many types of primary keys are there?
What is sql integrity?
What is time based sql injection?
What is full join in sql?
how to escape special characters in sql statements? : Sql dba
Why do we create stored procedures & functions in pl/sql and how are they different?
What information is needed to connect sql*plus an oracle server?
Enlist the characteristics of pl/sql?
What is crud stand for?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What are the different types of a subquery?
How do I edit a stored procedure?
Is sql free?
How do you remove duplicate records from a table?