Re: SQL Question : From MS SQL Server to Oracle

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 Thu Jun 24 1999 - 15:52:13 CDT