mysql - 按列组合 mysql 查询

Question

是否有按列组合 mysql 查询的方法？我有以下疑问

select  count(ticket_id) as numInProgress from ost_ticket where status
 = 'in progress' and topic_id not in (select topic_id from ost_org_site_map)

 select  count(ticket_id) as numAssigned from ost_ticket where status =
 'open' and topic_id not in (select topic_id from ost_org_site_map)

我正在尝试获取以下格式的结果

---numInProgress | numAssigned---
            2    |     8
---------------------------------

Answer 1

只需将它们用作 select 语句中的子查询，例如

SELECT ($statement1$),($statement2$)

或者您的疑问:

SELECT (select count(ticket_id) as numInProgress from ost_ticket where status = 'in progress' and topic_id not in (select topic_id from ost_org_site_map)) as numInProgress ,(select count(ticket_id) as numAssigned from ost_ticket where status = 'open' and topic_id not in (select topic_id from ost_org_site_map)) as numAssigned;