sqlsyntax,count,groupbyandaddedinstatement

2  

It's a little awkward looking, but how about?

看起来有点尴尬,但是怎么样?

select IDs.ID, ifnull(count(globals_lists.global_id),0) as group_count
from (select 3 as ID
             UNION select 4
             UNION select 5
             UNION select 6) as IDs
left join globals_lists on IDs.ID = globals_lists.global_id
group by IDs.ID
order by group_count desc;

1  

You could add a table with all desired values. Either inline, like below, or in a temporary table. Then you can use left join to match the number of rows.

您可以添加包含所有所需值的表。内联,如下,或临时表。然后,您可以使用左连接来匹配行数。

select  lst.nr
,       count(gl.id) as group_count
from    (
        select 3 as nr
        union all select 4
        union all select 5
        union all select 6
        ) lst
left join 
        globals_lists gl
on      lst.nr = gl.global_id
group by 
        lst.nr
order by 
        count(gl.id) desc

0  

Instead of COUNT(id), use COUNT(*) so it will return a count even if there are none, assuming 4 & 6 do exist:

使用COUNT(*)代替COUNT(*),因此即使没有,也会返回计数,假设4和6确实存在:

select global_id, count(*) as group_count
from globals_lists
where global_id in (3,4,5,6)
group by global_id
order by group_count desc;