Re: selecting only 10 rows

select * from {table_name} where ROWNUM < 11;

Ed Zappulla wrote in message <773mrd$gol$1_at_winter.news.rcn.net>...
>Does anyone know how to limit the number of rows returned from a select
>statement? I have 5000 rows in a table and just want to grab the first 10
>to look at a sample of them. I thought ROWId would do it but it doesn't
>seem to work. SQLSERVER uses set rowcount = 10.
>
>
Received on Thu Jan 07 1999 - 21:28:48 CST