"Rownum" in Informix

Posted in 2006

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