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: z1hou1 <z1hou1_at_gmail.com>
Date: Mon, 08 Oct 2007 02:50:42 -0000
Message-ID: <1191811842.356041.146660@o80g2000hse.googlegroups.com> 





Hmm..Did you try


SELECT orderno,count(orderno) FROM <table>
GROUP BY orderno


ORDER BY orderno



I am assuming here that the three character numeric to the prefix LM
is fixed.



Regards,


z1hou1
Received on Sun Oct 07 2007 - 21:50:42 CDT












Original text of this message













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