OraFAQ Forum: SQL & PL/SQL » question for reverse

Home » SQL & PL/SQL » SQL & PL/SQL » question for reverse (oracle 11g)

Mon, 11 November 2019 21:51

manoj12
Messages: 210
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

		question for reverse By: manoj12 on Mon, 11 November 2019 21:51
		Re: question for reverse By: Michel Cadot on Tue, 12 November 2019 00:39
		Re: question for reverse By: _jum on Tue, 12 November 2019 03:18
		Re: question for reverse By: John Watson on Tue, 12 November 2019 04:08
		Re: question for reverse By: shawaj on Thu, 21 November 2019 05:29
		Re: question for reverse By: Solomon Yakobson on Thu, 21 November 2019 07:50
		Re: question for reverse By: Bill B on Fri, 22 November 2019 10:39

Previous Topic:	Record Plus Prior Record - Single Row
Next Topic:	Break line as per required attached output.

Goto Forum:

]

Current Time: Fri Apr 26 10:43:31 CDT 2024