Re: Selects only the first 200 records aftering ordering from a table.

I don’t know watch does FIRST mean, but try
SELECT A, B, C
FROM table
WHERE Condition
AND rownum < 500
ORDER BY rowid , C, B

Colin Woods napisał(a) w wiadomości: <3535FC1F.1FE9_at_hotmail.com>...
>Folks,
>
>Can anyone help me ?
>
>I have a large table, where I only want to select up to a maximum of 500
>records.

.....
>
>Colin Woods.
Received on Thu Apr 16 1998 - 09:29:40 CDT