select first 10 * from ...

regards,
Steffen

-----Original Message-----
From: monaasn [mailto:monalisa@...]
Sent: Sunday, July 11, 2004 3:52 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] retrieve rownum

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



------------------------ Yahoo! Groups Sponsor --------------------~--> Make
a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links