At 08:59 AM 15/08/2003 +0000, you wrote:

>Does
>
>select last 5 * from customers
>
>work the same way?.
>
>lol.. :) just asking

No, but

select first 5 * from customers
order by cust_join_date desc

will do that.

Just making the point that a limited set isn't of much use in an unordered
set...

heLen

>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/
>
>
>
>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/