Dear all,
I have query sort order by value. I want just top 10 record. At MS
SQL Server I can use :

Where rownum <=10

How can I got the result with firebird ? The Firebird don't
recognized syntax rownum.

THX.

regards,
MONA