我有一个包含列的数据库:
ULB性别MaritialStatus类别
类别(一般、保留)和ulb的婚姻状态(已结婚、未婚、寡妇、离婚者)的性别(M,F)的可能值是200个位置的列表
现在,我想要编写查询以生成格式如下图所示的报告。
其中F_M =>女性结婚,F_D =>女性离婚,F_UM =>女性未婚,F_W =>女性寡妇等
我知道如何一个接一个地对数据运行单个查询,但有没有办法以更紧凑和更节省查询的方式生成此报告。
发布于 2018-05-28 19:32:51
在一个查询中使用多个查询,这些可以给你一个想法:
select t1.c, t2.c, t3.c
from
(select count(*) as c from new_table where date11="08/01/2015") as t1,
(select count(VchType) as c from new_table where date11="08/01/2015") as t2,
(select sum(Debit) as c from new_table where VchType="CASH SALES GODOWN") as t3;
或者:
SELECT 1 AS Deptnumber, Dept FROM tbl_students WHERE Dept IN ('A', 'B', 'C')
UNION
SELECT 2 AS DeptNumber, Dept FROM tbl_students WHERE Dept IN ('D', 'E')
UNION
SELECT 3 AS Deptnumber, Dept FROM tbl_students WHERE Dept IN ('F')
https://stackoverflow.com/questions/50565166
复制相似问题