Re: SQL Query Question
From: Kelly Wilkerson <kwilkerson_at_prosoftauto.com>
Date: Tue, 02 Jan 2001 07:50:39 -0600
Message-ID: <3A51DCAF.A5DA1A07_at_prosoftauto.com>
Date: Tue, 02 Jan 2001 07:50:39 -0600
Message-ID: <3A51DCAF.A5DA1A07_at_prosoftauto.com>
Thanks Kevin! I appreciate your time. That was just what I was looking for.
Kelly.
Kevin McDaniel wrote:
> It depends. Are you only wanting the top 10 or 20? If so, you can you use
> the Top-N query.
>
> SELECT column_list ROWNUM FROM
> (SELECT column_list FROM table
> ORDER BY Top-N_column)
> WHERE ROWNUM <= N
-- --------------------------------------------- Kelly Wilkerson Systems Engineer ProSoft Automation (205) 314-2816 (Voice) (205) 444-9932 (Fax) http://www.prosoftauto.com mailto:kwilkerson_at_prosoftauto.com ---------------------------------------------Received on Tue Jan 02 2001 - 14:50:39 CET