"Rownum" in Informix

Posted in 2006

Summary

Kuldeep asked how to do ROWNUM in Informix. Jonathan Stowe suggested rowid; Serge Rielau explained Oracle ROWNUM limits result sets. david showed SELECT SKIP 10 FIRST 5. Keshav noted that from IDS 10.00.xC3 SKIP and enhanced FIRST give pagination, applied after ORDER BY, unlike Oracle's ROWNUM which is assigned before it.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Kuldeep — 13 Apr 2006 23:44:49 -0700 — source: Usenet: comp.databases.informix

RowNum in Informix? How to implement it any syntax,ponters,e.g

↪ replying to Kuldeep

Jonathan Stowe — Fri, 14 Apr 2006 08:32:20 +0100 — source: Usenet: comp.databases.informix

On Fri, 2006-04-14 at 07:44, Kuldeep wrote: > RowNum in Informix? How to implement it > any syntax,ponters,e.g > You mean like select rowid from foo ? -- This e-mail is sponsored by http://www.integration-house.com/

↪ replying to Jonathan Stowe

Serge Rielau — Fri, 14 Apr 2006 12:23:24 -0400 — source: Usenet: comp.databases.informix

Jonathan Stowe wrote: > On Fri, 2006-04-14 at 07:44, Kuldeep wrote: >> RowNum in Informix? How to implement it >> any syntax,ponters,e.g >> > > You mean like > > select rowid from foo> > ? ROWNUM in Oracle is used to limit resultsets. E.g. SELECT * FROM T WHERE rownum < 5 So it's a "relative row number" rather than a rowid. Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab

↪ replying to Serge Rielau

david@smooth1.co.uk — 14 Apr 2006 17:23:45 -0700 — source: Usenet: comp.databases.informix

"So it's a "relative row number" rather than a rowid. " Select skip 10 first 5 a,b from tab1;

↪ replying to david@smooth1.co.uk

keshava.news@gmail.com — 15 Apr 2006 14:44:28 -0700 — source: Usenet: comp.databases.informix

Starting with version 10.00.xC3, IDS provides SKIP and enhanced FIRST clause to provide pagination. The main difference between using these and ROWNUM in oracle is, IDS starts counting the rows after the ORDER BY clause is evaluated where as Oracle's ROWNUMS is generated before the ORDER BY is evaluated. cheers, Keshav. Links to IDS manuals: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls652.htm http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls656.htm