Re: How to select first N rows?
Cosmo Lee <"* N O - S P A M * cosmo"@echonyc.com> escribi' en art'culo
<347780AD.D83651DE@echonyc.com>...
> Is there a way to select the first N rows from a table?
>
> i.e.: select the first 20 row from a table
>
Try :
SELECT field FROM table t1
WHERE 20 > ( SELECT COUNT(*) FROM table t2
WHERE t1.field > t2.field )
ORDER BY field
This selects the first 20 records of the following SELECT :
SELECT field FROM table
ORDER BY field
Hope that helps.
Xavi