Re: Top n in sql

From: David Russell <dbruce_at_kreative.net>
Date: Thu, 27 May 1999 21:28:58 GMT
Message-ID: <374db90c.2674375@news>

where rownum < 6

On Mon, 24 May 1999 14:26:07 -0500, "Doug Brown" <Doug.Brown_at_abbott.com> wrote:

>I want to return the top 5 users of yesterdays internet. I have a log table
>that has userid and date visited.
>
>select count(*)
>from logtable
>group by userid
>order by count(*) desc
>
>but I want to stop after the top five are returned.
>
>Anyone know this one?
>
>Thanks
>Doug Brown
>
>
Received on Thu May 27 1999 - 16:28:58 CDT