Subject RE: [firebird-support] Select with FB
Author slim
Many thanks to all. Pity they did not implement the last as well.
Many thanks

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: 01/07/2003 13:36
Subject: Re: [firebird-support] Select with FB

> Can any one tell me what the sintax is for select last 100. I know that
> Slect First 100 * from works ok but can not find and details for select

do an ORDER BY <something> DESC

In short: ordering the other way makes you select the 100 last :-)

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to