Message-Id: <10737.126320@fatcity.com> From: "Koivu, Lisa" Date: Wed, 10 Jan 2001 14:59:37 -0500 Subject: Top N query This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07B3F.DE2CDE94 Content-Type: text/plain; charset="iso-8859-1" OK, I apologize in advance, I know this has been discussed many times. I need to generate the top N, in this case 3, values for a query, like the example shown below. It has to be done in SQL, because I need to return this as a refcursor. (OPEN refcurcor FOR...) category1 10 category1 14 category1 2 category1 25 category2 14 category2 13 category2 55 category2 5 category3 14 category3 1 category4 5 I need to display this: category1 25 category1 14 category1 10 category2 55 category2 14 category2 13 category3 14 category3 1 category4 5 Can you hear me cursing.... Thanks in advance for any suggestions. Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." ------_=_NextPart_001_01C07B3F.DE2CDE94 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Top N query

OK, I apologize in advance, I know = this has been discussed many times.

I need to generate the top N, in this = case 3, values for a query, like the example shown below.  It has = to be done in SQL, because I need to return this as a refcursor.  = (OPEN refcurcor FOR...)

category1     = 10
category1     = 14
category1     = 2
category1     = 25
category2     = 14
category2    13
category2     = 55
category2    5
category3    14
category3    1
category4    5

I need to display this:

category1  25
category1  14
category1  10
category2  55
category2  14
category2  13
category3  14
category3  1
category4  5

Can you hear me cursing....

Thanks in advance for any = suggestions. 

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  = 33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The = information contained herein does not express the opinion or position = of Qode.com and cannot be attributed to or made binding upon =