鱻鯹鯹oоО

摘要： 问题描述：表machine id other...... 1 x 2 x 4 x 5 x 6 x 求ID连续的最大个数，对上例来说，4/5/6 是三个连续，最后应得值3 select b.id,count(*) count from (select id,rownum p from machine t order by id)... 阅读全文