27,579
社区成员
发帖
与我相关
我的任务
分享
select * from tb
where (abs(ISNULL(K1,0)-1.6)<offset)
OR (abs(ISNULL(K2,0)-1.6)<offset)
OR (abs(ISNULL(K3,0)-1.6)<offset)
select * from tb
where (K1-OFFSET<1.6 AND K1+OFFSET>1.6)
or (K2-OFFSET<1.6 AND K2+OFFSET>1.6)
or (K3-OFFSET<1.6 AND K3+OFFSET>1.6)
select * from tb
where (ISNULL(K1,0)-OFFSET<1.6 AND ISNULL(K1,0)-+OFFSET>1.6)
OR (ISNULL(K2,0)--OFFSET<1.6 AND ISNULL(K2,0)-+OFFSET>1.6)
OR (ISNULL(K3,0)--OFFSET<1.6 AND ISNULL(K3,0)-+OFFSET>1.6)
select * from tb
where (K1-OFFSET<1.6 AND K1+OFFSET>1.6)
OR (K2-OFFSET<1.6 AND K2+OFFSET>1.6)
OR (K3-OFFSET<1.6 AND K3+OFFSET>1.6)