正文
sql 查询多列 小于某值
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
select COUNT(*) from (
select ID,H1 AS Value from Table_1
union all
select ID,H2 from Table_1
union all
select ID,H3 from Table_1
union all
select ID,H4 from Table_1
union all
select ID,H5 from Table_1
)as a where ID=1 and Value < 5 select COUNT(*) from
(
select ID,H1 AS Value from Table_1 where ID=1
union all
select ID,H2 from Table_1 where ID= 1
union all
select ID,H3 from Table_1 where ID= 1
union all
select ID,H4 from Table_1 where ID= 1
union all
select ID,H5 from Table_1 where ID= 1
)as a where Value<5 select * from Table_1
Select
Case When H1<5 then 1 else 0 end
+Case When H2<5 then 1 else 0 end
+Case When H3<5 then 1 else 0 end
+Case When H1<5 then 1 else 0 end
+Case When H5<5 then 1 else 0 end as 小于5列的个数
from Table_1
