Re: SQL Help me
From: JDoe <x_at_x.com>
Date: Wed, 06 Jun 2001 23:33:29 GMT
Message-ID: <nbftht8uf2hhrbvjpeo44mp8lq66tdfm1l_at_4ax.com>
Date: Wed, 06 Jun 2001 23:33:29 GMT
Message-ID: <nbftht8uf2hhrbvjpeo44mp8lq66tdfm1l_at_4ax.com>
SELECT *
FROM CUSTOMER
WHERE ROWNUM < 21
ORDER BY CUSTOMER_ID
That should do it.
On 6 Jun 2001 01:58:33 -0700, korn_at_usa.net (Kittikorn Tongnimitsawat) wrote:
>Dear all,
>
>I am using Oracle Financial Service Apprication, OFSA. I need the SQL
>to select just first 20 ranks of the result. For example, SELECT *
>FROM customer ORDER BY customer_id; this statement shows me a number
>of reccord. I just want the first 20 record showed to me. I don't know
>how to do.
>
>Best regards,
>Korn
Received on Thu Jun 07 2001 - 01:33:29 CEST