Re: SQL: How to select first N rows?

I believe in version 7.23 there is. The fetaure is called first rows optimization. -Bill } } Is there a way to select the first N rows from a table? } } i.e.: select the first 20 row from a table } } Thanx } } -- } * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * } ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. } } Cosmo Lee Multi-User Computer Systems Brooklyn, NY } } "JUST SAY 'NO' TO SPAM" } * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * } } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net