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

On 10 8 , 11 50 , z1hou1 <z1h..._at_gmail.com> wrote:
> 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

Hi z1hou1.

it returns like this,

1	LM001	5
2	LM002	3
3	LM003	2
4	LM004	4
5	LM005	1

What I want is each count of same orderno IN SEQUENCIALY, not count of same orderno in whole rows.
Thanks a lot sincerely Received on Sun Oct 07 2007 - 21:56:00 CDT