sql - Change data show SQL

Question

I have this script

select 'clos' as name, COUNT(clos.ticket_cp) as counte 
from clos 
union all 
select 'encour',COUNT(en_cours.ticket_cp)   
from en_cours  
union all 
select 'gele',COUNT(gele.ticket_cp) as gele  
from gele 

and it returns a result like this:

encours  15
gele     10
clos     14

Is there any way to make it look like this

Name        encours  gele  clos
Nombre        15      10    14

标签： sql

Answer 1

您可以在中使用子查询select：

select (select COUNT(clos.ticket_cp) as counte from clos) as clos,
       (select COUNT(en_cours.ticket_cp) from en_cours) as en_cours,
       (select COUNT(gele.ticket_cp) from gele) as gele

这适用于大多数数据库。有些需要一个from子句，例如from dualor from sysibm.dummy1。