我有两个表，分别为A,B
先执行如下SQL语句
Select a.djbh,b.hwname,count(a.spid)/8+1 as ys,count(a.spid)%8 as lstms,min(dj_sort) as min_sort,max(dj_sort) as max_sort from 表A a(nolock),表B b(nolock) where a.djbh='75466' and a.dhw=b.hw group by a.djbh,b.hwname Select a.djbh,b.h
先执行如下SQL语句
Select a.djbh,b.hwname,count(a.spid)/8+1 as ys,count(a.spid)%8 as lstms,min(dj_sort) as min_sort,max(dj_sort) as max_sort from 表A a(nolock),表B b(nolock) where a.djbh='75466' and a.dhw=b.hw group by a.djbh,b.hwname Select a.djbh,b.h
