Re: Possible Use of a Cursor

From: Paul Izzo <paul.izzo_at_mosca-ag.com>
Date: 23 Feb 2005 02:57:29 -0800
Message-ID: <1109156249.658526.161330@f14g2000cwb.googlegroups.com>

So now I have a solution for finding the first step of all the instructions I want. I used the following query:

   select
   distinct(papp.INSTRUCTION_NR),papp.MACHINE_PROC,pa pp.POSITIONS_NR    from w100.papp,
   (select min (papp.POSITIONS_NR)
   from w100.papp)
   where papp.MACHINE_PROC in (3530,3430,3500)

Now I'm interested in finding out the second step in an INSTRUCTION can I do something like MIN + 1 to get the 2nd step and MIN + 2 to get the 3rd step and so on... Is this possible? Received on Wed Feb 23 2005 - 04:57:29 CST