php - 如何从数据库中选择不同的列，每个列给出另一个查询结果的总和(或类似的)？

Question

这是示例查询

SELECT 
    name, 
    sum(SELECT id FROM mytable WHERE cond='1' and cond2='2') as mysum1, 
    sum(SELECT id FROM mytable WHERE cond3='3' and cond4='4') as mysql2 
FROM 
    mytable 
WHERE 
    userid='1' and status='1';

显然这不起作用，但我想你现在可以明白我的意思了。如何以这种方式检索记录。

Answer 1

试试这个

SELECT 
    name, 
    (SELECT SUM(id) FROM mytable WHERE cond='1' and cond2='2') as mysum1, 
    (SELECT SUM(id) FROM mytable WHERE cond3='3' and cond4='4') as mysql2 
FROM 
    mytable 
WHERE 
    userid='1' and status='1';