Re: Who supports the LIMIT clause in a SELECT statement
Informix IDS 7.3x:
SELECT FIRST <num> * FROM bar;
Leonard Nisenoff wrote:
> "set rowcount <num>" will return the first <num> records.
>
> set rowcount 100
> go
> select * from bar> go
>
> On Tue, 9 Feb 1999 22:40:42 GMT, rmah@arena-i.com (Robert S. Mah)
> wrote:
>
> >MySQL has this cool feature where you can specify how many (and
> >which) rows are returned from a SELECT statement. I was wondering
> >if any other, more full featured, databases (e.g. Oracle, Sybase,
> >Informix, etc.) have this feature.
> >
> >You would use it something like this:
> >
> > SELECT * FROM bar LIMIT 30, 20> >
> >In order retreive rows 30 through 49 of the table returned by the
> >SELECT.
> >
> >Cheers,
> >Rob
--
Mit freundlichen Grüßen / with best regards :-)
-\\|/-
)ø^o(
+=========oOOo==(_)==oOOo=======Mail-Client: Netscape V4.5==+
| Ernst Sauerwein Siemens ITService GmbH & Co. oHG|
| =============== ISC-D 144 |
| Microsoft Certified OLTP-Systems |
| Professional INFORMIX® Database Support |
| Tel: +49 89 3601 2699 Area South Europe |
| FAX: +49 89 3601 2402 Berliner Str.95,III/C190-193 |
| NERV: mailto:sauerwein.muc@sni.de |
| EMAIL: mailto:ernst.sauerwein@mch.siemens.de |
| EMAIL: mailto:ernsts@informix.com |
| FTP: ftp://ftp.mch.sni.de/ (external) |
| ftp://MB184060.mch.sni.de/ (internal) |
| WWW: http://its.mch.sni.de/ (external) |
| http://MB184060.mch.sni.de/ (internal) |
+===========================================================+