Re: How can I know how many same orderno is shown in rows sequentially?

I found another way. It uses subquery only.

 SELECT T3.ORDERNO, COUNT(*), T3.CHANGE_MIN_SEQ   FROM (SELECT T1.*

               , (SELECT MIN(T2.SEQ)
                    FROM ORDERMST T2
                   WHERE T2.FACTORYDAY = T1.FACTORYDAY
                     AND T2.SEQ >T1.SEQ
                     AND T2.ORDERNO <> T1.ORDERNO)
                     AS CHANGE_MIN_SEQ

         FROM ORDERMST T1
         WHERE T1.FACTORYDAY = '20071002'
         ) T3

 GROUP BY T3.ORDERNO, T3.CHANGE_MIN_SEQ
 ORDER BY T3.CHANGE_MIN_SEQ; Received on Wed Oct 10 2007 - 02:46:28 CDT