select top 20 * from vjoblist where validTime>getdate() and ( charindex(',005',','+area)>0 ) and [id] not in (select top 260 id from vjoblist where validTime>getdate() and ( charindex(',005',','+area)>0 ) order by j_addtime desc ) order by j_addtime desc 完整语句
[id] not in (select top 260 id from vjoblist where validTime>getdate() and ( charindex(',005',','+area)>0 ) order by j_addtime desc ) order by j_addtime desc
完整语句