Hello,

I'm facing one easy problem, but I don't know how to solve it in informix. I want do one query that return one to count in one column:

Select nom_cliente,num_row from table;

I wanna get the result

Fernando 1
Fernando 2
Joao 3
Maria 4
John 5
James 6


Could someone help me ???

begin work;
create sequence myseq;
select myseq.nextval,s.firstName,s.lastName from students s;
drop sequence myseq;commit work;


I got that way to solve it