SELECT
COUNT (1)
FROM
(
select
(
CASE
WHEN b.type = 0 then '自住户' WHEN b.type = 1 then '租户' WHEN b.type = 4 then '常客' else '其他'
end
) "type"
from
zhsq_housing_information b
left join zhsq_user_info a on
b.user_id = a.id
where to_char (to_Date(b.create_time,'yyyy-MM-dd HH24:mi:ss'),'yyyy-MM-dd') between to_char (to_Date(#{startTime},'yyyy-MM-dd HH24:mi:ss'),'yyyy-MM-dd')
and to_char (to_Date(#{endTime},'yyyy-MM-dd HH24:mi:ss'),'yyyy-MM-dd')
)to_char (to_Date(b.create_time,'yyyy-MM-dd HH24:mi:ss'),'yyyy-MM-dd') between to_char (to_Date(#{startTime},'yyyy-MM-dd HH24:mi:ss'),'yyyy-MM-dd')
and to_char (to_Date(#{endTime},'yyyy-MM-dd HH24:mi:ss'),'yyyy-MM-dd')
)
本文著作权归作者 [ admin ] 享有，未经作者书面授权，禁止转载，封面图片来源于 [ 互联网 ] ，本文仅供个人学习、研究和欣赏使用。如有异议，请联系博主及时处理。