You say ROWNUM, I say ROWID

Posted in 2000

Carlos Benjamin — Tue, 2 May 2000 05:33:58 -0700 — source: Informix-list mailing list archive (1991-1998)

batti <batti@digito.com> wrote: >..I want to know how to use ROWNUM or similar thing in Informix... > >In manual site, I already figure out that informix doesn't have ROWNUM ... > >.Isn't there another way..?? Sure. Head back to the manuals and check out 'rowid'. carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com

↪ replying to Carlos Benjamin

Harry Sheng — Wed, 3 May 2000 12:36:44 -0400 — source: Informix-list mailing list archive (1991-1998)

I do not know what is your purpose to use ROWNUM. In Oracle, I mostly use ROWNUM to select the first n records and give each retrieved row a sequential number. If this is what you want to do, Informix "SELECT" statement let you to be able to select the first n rows. But I do not know Informix gives you a method to assign a sequential number to every retrieved row in its SQL statement. Harry Carlos Benjamin wrote in message <8emm5c$l4a$1@news.xmission.com>... > >batti <batti@digito.com> wrote: >>..I want to know how to use ROWNUM or similar thing in Informix... >> >>In manual site, I already figure out that informix doesn't have ROWNUM ... >> >>.Isn't there another way..?? > >Sure. Head back to the manuals and check out 'rowid'. > > >carlos > >Currently on hiatus from unemployment. >---------------------- >Do you do Linux? :) >Get your FREE @linuxstart.com email address at: http://www.linuxstart.com