Have a look on the new FIRST ... SKIP clause in the Firebird v1.0
Release Notes page 9f.

SELECT [FIRST (<integer expr m>)] [SKIP (<integer expr n>)]

For example:

SELECT FIRST 5 DISTINCT FIELD FROM MYTABLE;

HTH,
Thomas Steinmaurer
http://www.iblogmanager.com

> -----Original Message-----
> From: Rotandiko Sastroprawiro [mailto:rsastroprawiro@...]
> Sent: Monday, June 03, 2002 6:13 AM
> To: 'ib-support@yahoogroups.com'
> Subject: [ib-support] ROWNUM
>
>
> Hello,
>
> Is there any SQL command that have similiarly function like
> ROWNUM , example
> :
>
> "SELECT TITLE FROM BOOK WHERE ROWNUM <= 5 ORDER BY TITLE" ?
>
> thanks,
>
> Diko
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>