Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I know how many same orderno is shown in rows sequentially?

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

From: deneb <cygdeneb_at_yonsei.ac.kr>
Date: Wed, 10 Oct 2007 00:46:28 -0700
Message-ID: <1192002388.615950.304630@k79g2000hse.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US