查询语句集合

 

#查询时间段 所有数据。进入到对应的数据存储表里面
select * from repo_onlineuser where left(create_time,10) = '2021-06-28'

 

SELECT * FROM cm.tb_customerinfo WHERE left(create_time,10) < '2021-07-07' AND STATUS=1 AND CustomerNumber is not NULL#不等于空

is not NULL表示 #不等于空
SELECT DISTINCT CustomerNumber from cm.tb_customerinfo WHERE left(create_time,10) < '2021-07-07' AND STATUS=1 AND CustomerNumber is not NULL##去重

DISTINCT CustomerNumber 表示 去重 字段

 

##昨日数据统计第一种查法

SELECT COUNT(DISTINCT CustomerNumber) from cm.tb_customerinfo WHERE LEFT(create_time,10) < '2021-07-07' AND STATUS=1

##昨日数据统计第二种查法
SELECT count( distinct CustomerNumber) from cm.tb_customerinfo where   create_time<'2021-07-07 00:00:00' and status=1