sql 求解释 !求解释!
select
e.unit_id,
e.unit_name,
f.temp_id,
f.temp_name,
f.temp_type,
g.pro_id,
g.pro_cn_name + '(' + g.pro_en_name + ')' pro_name,
h.admin_id, h.name,
d.lost,
convert(varchar(10), d.min_data_time, 20) min_data_time
from
(
select a.unit_id, a.min_data_time, COUNT(*) lost
from
(
select unit_id, DATEADD(wk, DATEDIFF(wk, 0, DATEADD(day, -1, MIN(data_time))), 0) min_data_time
from lz_product_unit_value
group by unit_id
) a cross join
(
select distinct DATEADD(wk, DATEDIFF(wk, 0, DATEADD(day, -1, day_time)), 0) day_time
from lz_workday
where work = '1' --1 表示周一到周五的工作日
) b
left join lz_product_unit_value c
on a.unit_id = c.unit_id and b.day_time = DATEADD(wk, DATEDIFF(wk, 0, DATEADD(day, -1, c.data_time)), 0)
where b.day_time >= a.min_data_time
and b.day_time <= DATEADD(wk, DATEDIFF(wk, 0, DATEADD(day, -1, GETDATE())), 0)
and c.unit_id is null
group by a.unit_id, a.min_data_time
) d
join lz_product_unit e on d.unit_id = e.unit_id
join lz_product_template f on e.temp_id = f.temp_id
join lz_product g on f.pro_id = g.pro_id
join lz_admin h on e.admin_id = h.admin_id
where f.temp_type = '1' -- 1表示按照‘周’频率计算
e.unit_id,
e.unit_name,
f.temp_id,
f.temp_name,
f.temp_type,
g.pro_id,
g.pro_cn_name + '(' + g.pro_en_name + ')' pro_name,
h.admin_id, h.name,
d.lost,
convert(varchar(10), d.min_data_time, 20) min_data_time
from
(
select a.unit_id, a.min_data_time, COUNT(*) lost
from
(
select unit_id, DATEADD(wk, DATEDIFF(wk, 0, DATEADD(day, -1, MIN(data_time))), 0) min_data_time
from lz_product_unit_value
group by unit_id
) a cross join
(
select distinct DATEADD(wk, DATEDIFF(wk, 0, DATEADD(day, -1, day_time)), 0) day_time
from lz_workday
where work = '1' --1 表示周一到周五的工作日
) b
left join lz_product_unit_value c
on a.unit_id = c.unit_id and b.day_time = DATEADD(wk, DATEDIFF(wk, 0, DATEADD(day, -1, c.data_time)), 0)
where b.day_time >= a.min_data_time
and b.day_time <= DATEADD(wk, DATEDIFF(wk, 0, DATEADD(day, -1, GETDATE())), 0)
and c.unit_id is null
group by a.unit_id, a.min_data_time
) d
join lz_product_unit e on d.unit_id = e.unit_id
join lz_product_template f on e.temp_id = f.temp_id
join lz_product g on f.pro_id = g.pro_id
join lz_admin h on e.admin_id = h.admin_id
where f.temp_type = '1' -- 1表示按照‘周’频率计算
...全文
相关推荐
sql server绿色版,绝对好用!
sql server绿色版,绝对好用!本人正正使用,但仍建议下完亲自杀毒检测。网上搜集来的,请用7zip解压。
关于SQL中,连续天数问题的求解
这里写自定义目录标题欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题,有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能,丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 欢迎使用Ma...
乐优商城sql文件,最新!
乐优商城最新sql文件,具体项目内容请参考博客!
Sql 问题,时间顺序问题求解
一个Sql难题,不知道如何解决。在论坛中发贴求解.
SQL_execl 文件导出,使用SQL语句!
很好的SQL 导出execl文件! 使用SQL语句! 能完全的导出数据!很实用哦!


