Re: How to limit # of rows returned by SELECT

From: Gary Bender <gbender_at_rt66.com>
Date: 1996/02/08
Message-ID: <4fds1a$rfl_at_mack.rt66.com>#1/1


gordon_at_cu.comp-unltd.com (Screemin!) wrote:
>
>Does anybody know if there is a way to limit the number of records
>returned by a SELECT statement? I have a large ODBC database
>where I would like to display the first 50 records that match a certain
>criteria, but I don't want the user to have to wait while the SELECT
>call processes all 7.2 quintillion records as it is a speed-critical
>application and has to happen in a couple of seconds.
>
>I tried SELECT *, COUNT(*) FROM TABLE WHERE COUNT(*) <=50
>but of course this didn't work, nor should it logically.
>
>Any help would be appreciated!

I have not checked the impact on execution time, but in MS-Access use the Top n property of the Query:
 SELECT TOP 100 * FROM ...;

  • J. Gary Bender Tijeras, NM
Received on Thu Feb 08 1996 - 00:00:00 CET

Original text of this message