Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |