Re: selecting only 10 rows

add to the where statement --- 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 - 20:54:20 CST