> -----Original Message-----
> From: shyang [mailto:shyang@...]
> Sent: Viernes 21 de Diciembre de 2001 0:42

> In sqlsever,
>
> 'select top 3 name from user_table where ........'

Please use PLAIN TEXT not HTML email in our lists. Thank you.

You can achieve that with Firebird's FIRST that's applied to the SELECT
part.
In Interbase, the ROWS keyword goes after the ORDER BY clause.

C.