Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007

    Unanswered: Query, showing sequence returned !


    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 ???

  2. #2
    Join Date
    Oct 2007


    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts