Does

select last 5 * from customers

work the same way?.

lol.. :) just asking

Regards,
S.
--- In firebird-support@yahoogroups.com, "Richard Pendered"
<rpendered@t...> wrote:

> you still need to specify the column list:
> select first 5 * from customers;
>
> -----Original Message-----
> From: rockwithme77 [mailto:rockwithme77@y...]
> Sent: 15 August 2003 09:52
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: SQL Limit Command
>
>
> Hi Michael,
>
> Select first 5 from customers;
>
> This gives an error.
>
> Can you help me out pls.
>
> Regards,
> S.
>
> --- In firebird-support@yahoogroups.com, "Michael Olschimke"
> <olschimke@g...> wrote:
> >
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Check
> >
> > SELECT FIRST X SKIP X
> >
> > HTH
> >
> > Michael
> >
> > - -----Original Message-----
> > From: rockwithme77 [mailto:rockwithme77@y...]
> > Sent: Freitag, 15. August 2003 09:59
> > To: firebird-support@yahoogroups.com
> > Subject: [firebird-support] SQL Limit Command
> >
> >
> > Hi,
> >
> > Is there a way to limit SQL record fetch in FB like the limit
> > command ?
> >
> > Regards,
> > S.
> >
> >
> >
> >
> > - ------------------------ Yahoo! Groups Sponsor -----------------

--

> --~--> Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon

or

> Lexmark Printer at Myinks.com. Free s/h on orders $50 or more to the
> US & Canada. http://www.c1tracking.com/l.asp?cid=5511
> > http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/67folB/TM
> > - ----------------------------------------------------------------

--

> ---~->
> >
> > To unsubscribe from this group, send an email to: firebird-

support-

> unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> > -----BEGIN PGP SIGNATURE-----
> > Version: PGP 8.0
> >
> > iQA/AwUBPzyUMuHaa+PgJ6iLEQJvZgCeMVhr+MpnrwSQc4UhdDIxSDkoGbcAoO9Z
> > Zk2J8FizbZrw6oW1rTrGFLFp
> > =e4dn
> > -----END PGP SIGNATURE-----
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/