Re: How to limit # of rows returned by SELECT
From: Jason Lincoln <jlincoln_at_mailhost.onramp.net>
Date: 1996/02/24
Message-ID: <4gnbk6$r9h_at_news.onramp.net>#1/1
Date: 1996/02/24
Message-ID: <4gnbk6$r9h_at_news.onramp.net>#1/1
In your select use the constraint where rownum < some_number
In article <Pine.SOL.3.91.960208160943.3865C-100000_at_mail>,
hrothenb_at_mail.bcpl.lib.md.us says...
>
>Before the select use the
> set rowcount 50
>command.
>
>On Thu, 8 Feb 1996, 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
>> I tried SELECT *, COUNT(*) FROM TABLE WHERE COUNT(*) <=50
>> but of course this didn't work, nor should it logically.
Received on Sat Feb 24 1996 - 00:00:00 CET