区间连续性MAC区间的连续区间解法!
[@more@]select b.work_order, min (b.macid) Start_macid, max (b.macid) End_macidfrom (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='20100900663'
and t.macid is not null
and t.macid<>'N/A'
order by t.work_order, t.macid) a) b
group by b.work_order, b.cc
order by b.work_order, b.cc
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23307206/viewspace-1043124/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23307206/viewspace-1043124/