数据表字段 id,packageno,cust,lotno.
部分数据：
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140214137 12653627 4044
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218039 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218035 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4048
SYS140218042 12653627 4044
SYS140218042 12653627 4044
SYS140218042 12653627 4044
SYS140218042 12653627 4044
SYS140218042 12653627 4044
能否对lotno进行分组得到这样的结果？
12653627 4044 15
12653627 4048 45
12653627 4044 15
------解决方案--------------------
修改一下：
select cust,lotno,COUNT(*)
(
select *,
ROW_NUMBER() over(order by getdate()) as rowid,
ROW_NUMBER() over(partition by lotno order by getdate()) rownum
from test
)t
group by cust,lotno,rowid - rownum