Re: SQL Question : From MS SQL Server to Oracle

From: Erwin jasinski <hexalog_at_wanadoo.fr>
Date: Fri, 25 Jun 1999 10:02:01 +0200
Message-ID: <7kvd92$dhn$1@wanadoo.fr>

Andy,

It's OK !
Thank you very much.
Erwin

andrew_at_soft-solutions-inc.com a écrit dans le message <377299e5.87491766_at_news.ufl.edu>...
>On Thu, 24 Jun 1999 16:01:38 +0200, "Erwin JASINSKI"
><hexalog_at_wanadoo.fr> wrote:
>
>I think you will get what you are looking for with this:
>
>SELECT T1.Col1
>FROM Table T1
>WHERE ....
> and rownum < 11
>ORDER BY T1.Col1;
>
>
>rownum is a special column that counts the number of rows returned -
>the above query will give you the first 10 rows of the results set.
>
>Thanks,
>Andy
Received on Fri Jun 25 1999 - 03:02:01 CDT