Q: How to count & put a limit to the output at the same time ??

From: <monsri_at_my-deja.com>
Date: Fri, 04 Jun 1999 10:36:32 GMT
Message-ID: <7j8a7g$9jk$1@nnrp1.deja.com>

Hello here,

I have a question (for gurus ?):
I'd like to perform a COUNT(*), but with a max. of rows returned that I can choose (this max. of rows must contain the N first max. counts). For instance, instead of getting (unsorted): NAME COUNT(*)
---- --------

p_15         8
n_2         20
n_3         19
n_1         20
p_24        11
n_4         15
p_28        10
n_6         12

if I only need the 5 first max. COUNT(*), I'll get: NAME COUNT(*)
---- --------

n_1         20
n_2         20
n_3         19
n_4         15
n_6         12

How to tell Oracle to stop as soon as I have my 5 rows ? I don't think it's possible in SQL, so did anybody write anything similar in PL/SQL please ?!?

Thanks a lot for any enlightement !

Regards,
Seb

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 04 1999 - 05:36:32 CDT