Re: SQL Question: Return top 5

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 26 Aug 1998 19:27:20 +0200
Message-ID: <6s1gft$j17$1@pascal.a2000.nl>

>how could I get it to display just the top 5 names.

    select *
    from
    ( select first_name|| ' ' || last_name fullname, count(*)

      from incidents
      GROUP BY first_name|| ' ' || last_name
      ORDER BY 2 DESC

    )
    where rownum <= 5;

Arjan. Received on Wed Aug 26 1998 - 12:27:20 CDT