That will query the first 10 records and return those that match the WHERE
clause. coulb be 10, could be 0.
Gennaro Napolitano wrote in message <37A1B8D1.C05965AE_at_italdata.it>...
>Hy
>
>You can use the pseudocolumn rownum inside the where condition:
>
>SELECT ... FROM .. WHERE .... AND ROWNUM < 10;
>
>to get the first 10 records.
>
>Hope this helps
>
>Ciao Gennaro
>
>Seyed Razavi wrote:
>
>> Hi,
>>
>> After years of working with MS-SQL I need to develop a program (using
Java)
>> for an Oracle database. Is there a way of limiting the number of results
>> returned in the same manner as SET ROWCOUNT in MS-SQL? I am using Oracle
8
>> Enterprise version.
>>
>> Any help would be appreciated.
>>
>> --
>> Cheers,
>>
>> Seyed
>> seyed_at_kmpinternet.com
>> http://strata.kmpinternet.com/
>
Received on Fri Jul 30 1999 - 15:50:31 CDT
