Re: [firebird-support] How to return only a few rows from select sql statement
trskopo wrote: Suppose I have a sql statement : select * from table Is that possible to return only a few rows from that statement (not the whole result), just like MySQL? http://www.firebirdfaq.org/faq111 HTH -- Milan Babuskov == The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ==
RES: [firebird-support] How to return only a few rows from select sql statement
Try: select first 5 * from table De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Milan Babuskov Enviada em: sexta-feira, 20 de janeiro de 2012 09:40 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] How to return only a few rows from select sql statement trskopo wrote: Suppose I have a sql statement : select * from table Is that possible to return only a few rows from that statement (not the whole result), just like MySQL? http://www.firebirdfaq.org/faq111 HTH -- Milan Babuskov == The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard == [Non-text portions of this message have been removed]
[firebird-support] How to return only a few rows from select sql statement
Hi all, Suppose I have a sql statement : select * from table Is that possible to return only a few rows from that statement (not the whole result), just like MySQL? Thanks and regards, Sugiarto
Re: [firebird-support] How to return only a few rows from select sql statement
Of course, you can to use clauses FIRST, SKIP or ROW TO Additionally, you can use a WHERE clause. Greetings. Walter. On Thu, Jan 19, 2012 at 11:46 PM, trskopo trsk...@yahoo.com wrote: ** Hi all, Suppose I have a sql statement : select * from table Is that possible to return only a few rows from that statement (not the whole result), just like MySQL? Thanks and regards, Sugiarto [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org 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 * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/