Home » SQL & PL/SQL » SQL & PL/SQL » question for reverse (oracle 11g)
question for reverse [message #678113] Mon, 11 November 2019 21:51 Go to previous message
manoj12
Messages: 197
Registered: March 2008
Location: India
Senior Member
Hi Team,

I wanted your help for the below question

The below is my source query
ID   QID    QNAME
1    12      MANOJ
2    13      MEERA
3    14      RAM
4    15      RAJ
5    16      KRISHNA

I wanted to write a query having output as shown below

QID   QNAME
21    RAJ
31    KRISHNA
41    MANOJ
51    MEERA
61    RAM 

Appreciate your help

Regards
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Record Plus Prior Record - Single Row
Next Topic: Break line as per required attached output.
Goto Forum:
  


Current Time: Wed Jan 22 10:41:50 CST 2020