Top N query

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Wed, 10 Jan 2001 14:59:37 -0500
Message-Id: <10737.126320@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Top N query</TITLE>
</HEAD>
<BODY>

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
 <A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A>


"The =
information contained herein does not express the opinion or position = of Qode.com and cannot be attributed to or made binding upon = Received on Wed Jan 10 2001 - 13:59:37 CST