Hi
U can use SELECT FIRST n from table to retorn n records from select.
Search for FIRST and SKIP in documentation.

Regards,
Paul

|-----Original Message-----
|From: firebird-support@yahoogroups.com [mailto:firebird-
|support@yahoogroups.com] On Behalf Of Shariful Alam
|Sent: Friday, May 19, 2006 8:28 PM
|To: firebird-support@yahoogroups.com
|Subject: [firebird-support] Finding Top n SQL Statement
|
|I need to retrieve Top n Product or Something like
|that. How can I get it through sql statement?
|Interbase has ROWS 1 TO n this facility. But firebird
|does not support ROWS. Is there any way to get this?
|
|Best Regards
|Md. Shariful Alam Khan
|
|__________________________________________________
|Do You Yahoo!?
|Tired of spam? Yahoo! Mail has the best spam protection around
|http://mail.yahoo.com
|
|
|
|++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
|Visit http://firebird.sourceforge.net and click the Resources item
|on the main (top) menu. Try Knowledgebase and FAQ links !
|
|Also search the knowledgebases at http://www.ibphoenix.com
|
|++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
|Yahoo! Groups Links
|
|
|
|
|