该SQL示例用于生成报表表头，通过多个UNION子查询组合数据，包括不同标识ID、日期、名称和数量单位，主要用于展示'小计'及不同阶段初筛阳性的统计数据。查询结果按ID转换为数值和数量单位降序排列。
SELECT D.ID, D.DD_DATA, D.NAME,D.N
FROM (
SELECT R.ID || '004' AS
ID, R.DD_DATA, '小计' AS NAME, '小计' AS N
FROM REHR_DD_CODE R
WHERE R.DD_NAME = 'REHR_SEX_DISEASE'
UNION
SELECT
R.ID || '001' AS ID, R.DD_DATA, '第一次初筛阳性' AS NAME, 'N' AS N
FROM REHR_DD_CODE R
WHERE R.DD_NAME = 'REHR_SEX_DISEASE'
UNION
SELECT
R.ID || '001' AS ID, R.DD_DATA, '第一次初筛阳性' AS NAME, '%' AS N
FROM REHR_DD_CODE R
WHERE R.DD_NAME = 'REHR_SEX_DISEASE'
UNION
SELECT
R.ID || '002' AS ID, R.DD_DATA, '第二次初筛阳性' AS NAME, 'N' AS N
FROM
最低0.47元/天 解锁文章
扫一扫
1246
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
