Many thanks to all. Pity they did not implement the last as well.
Many thanks
Slim

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: 01/07/2003 13:36
To: firebird-support@yahoogroups.com
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

Last

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
http://www.upscene.com



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/