积累小结：WITH AS用法

WITH AS的含义 WITH AS短语，也叫做子查询部分（subquery factoring），可以让你做很多事情，定义一个SQL片断，该SQL片断会被整个SQL语句所用到
例如：

WITH Tab AS (
SELECT CONVERT(varchar(100), [DateTime], 23) as kk,[UserId] FROM [OperateSystem].[dbo].[Analysis_Behavior_Xqly] where ModelName
in (‘达达数学’,‘达达阅读’,‘妈咪小厨’,‘科学探索’,‘亲子俱乐部’,‘数学逻辑’,‘艺术启蒙’,‘音乐律动’,‘绘本阅读’)
and UserId in (SELECT userid FROM [xuequnet].[dbo].[u_userinfo] where xxtschoolid=‘1747’ and role=0)
and DateTime between ‘2020-12-01 17:32:55.087’ and ‘2020-12-31 17:32:55.087’
group by CONVERT(varchar(100), [DateTime], 23),[UserId]

)
select COUNT(0) from Tab

TRUNCATE TABLE T_ExLog --清理数据资料,表还可以继续用