sql 查询

连续区域取数

 select sid,min(b.eid) as eid from 

    (select  id+2 as sid  from txtTempTable where tc1 like 'Name*') as a,

      (select id as eid  from txtTempTable where tc1='Page') as b 

        where sid<b.eid

       group by sid

                        16,18, 22,23

两表对应关联

select aa.sid,aa.eid,
(select top 1 tc2 from txtTempTable where tc1 like "Analyte*" and id>aa.sid-14 and id<aa.eid)
 as xmmc  from   
(
  select sid,min(b.eid) as eid from 
    (select  id+2 as sid  from txtTempTable where tc1 like 'Name*') as a,
      (select id as eid  from txtTempTable where tc1='Page') as b 
        where sid<b.eid
       group by sid
 ) as aa