dynamic row sequence

Posted in 2010

Cesar Inacio Martins — Fri, 10 Sep 2010 11:45:05 -0700 (PDT) — source: Usenet: comp.databases.informix

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