这是怎么了？
select NULL as "LINK",
DISTINCT HARDWAREOVERZICHT_STATIC."TOPDESK_vestiging" as "LABEL",
count( ZAM_BUILDING) as "STORK7"
from HARDWAREOVERZICHT_STATIC
where Omgeving = 'STORK7'
and "TOPDESK_heeftattentie" = 0
group by HARDWAREOVERZICHT_STATIC."TOPDESK_vestiging",ZAM_BUILDING
order by HARDWAREOVERZICHT_STATIC."TOPDESK_vestiging" desc
DISTINCT是紧随其后SELECT且适用于该子句中所有列的关键字。但是，通常不需要group by：
select NULL as "LINK", s."TOPDESK_vestiging" as "LABEL",
count( ZAM_BUILDING) as "STORK7"
from HARDWAREOVERZICHT_STATIC s
where Omgeving = 'STORK7' and "TOPDESK_heeftattentie" = 0
group by s."TOPDESK_vestiging"
order by s."TOPDESK_vestiging" desc;
我从中删除ZAM_BUILDING了group by。否则，count()将始终为0或1。我还添加了一个表别名。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句