select b.work_order, min (b.macid) Start_macid, max (b.macid) End_macid
from (select a.work_order,a.macid, to_char (to_number(a.macid,'xxxxxxxxxxxxxxxxxxxxxx')- rownum) cc
from (select t.work_order,t.macid,t.serial_number
from sajet.g_sn_status t
where t.work_order='20091100373'——输入工单
and t.macid is not null
order by t.work_order, t.macid) a) b
group by b.work_order, b.cc
order by b.work_order, b.cc
2010年8月10日——16进制MACID区间的连续性查询
最新推荐文章于 2024-07-23 18:27:01 发布