问SQL:如何计算特定顺序中的项

EN

select *, (select count(1) 
           from table t1 
           where t1.PACKAGE_ID = t.PACKAGE_ID and 
                 t1.ITEM_ID <= t.ITEM_ID
           ) as COUNT 
from table t;

SELECT PACKAGE_ID, ITEM_ID
    , ROW_NUMBER() OVER (PARTITION BY PACKAGE_ID ORDER BY PACKAGE_ID, ITEM_ID) AS THE_COUNT
FROM your_table

select t.*,
       (@rn := if(@p = package_id, @rn + 1,
                  if(@p := package_id, 1, 1)
                 )
       ) as counter
from t cross join
     (select @rn := 0, @p := -1) params
order by package_id, item_id;