> 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