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

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

[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