Re: dynamic row sequence

Posted in 2010

Holger de Wall — Fri, 10 Sep 2010 21:27:48 +0200 — source: Usenet: comp.databases.informix

Hi, "... In Dynamic Server, you can use the rowid column that is associated with a table row as a property of the row. ..." from http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?tab=search&searchWord=rowid select ROWID, name from users where state = 'NY'; -- Holger Am 10.09.2010 20:45, schrieb Cesar Inacio Martins: > Hi, > > I need a resource , what is common in any other database... > > Return the sequence # of the rows returned from select, something like: > > select func_rownu(), name from users > where state = 'NY'; > 1 john > 2 katty > 3 mike > 4 nattan > and so on... > > So , what I need is this "virtual serial/sequence" of the rows returned... > Anyone already do this ? > > Cesar > > > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list