Re: SQL Query Question

From: Kevin McDaniel <kmcdaniel96_at_home.com>
Date: Sat, 30 Dec 2000 04:18:39 GMT
Message-ID: <zmd36.52657$Y6.11730530_at_news1.mntp1.il.home.com>


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 Received on Sat Dec 30 2000 - 05:18:39 CET

Original text of this message