> -----Original Message-----
> From: Svein Erling [mailto:svein.erling.tysvaer@...]
> Sent: Monday, 1 September 2003 6:43 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Some Basic ?s
>
>
> > 4.How to fetch a n th row in a table (or in a SELECT statement)
> > Eg. The student whose rank is 22)
>
> try something like
> SELECT FIRST 1 SKIP 21 RANK, STUDENT
> FROM STUDENTS
> WHERE <some limiting criteria>
> ORDER BY RANK
>
> HTH,
> Set
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>