with t as (
select candidateId
from vote
group by candidateId
order by count(*) desc
limit 1
)
select name
from candidate right join t
on id = t.candidateId
Leetcode_574_当选者_SQL
最新推荐文章于 2022-04-07 13:52:00 发布
with t as (
select candidateId
from vote
group by candidateId
order by count(*) desc
limit 1
)
select name
from candidate right join t
on id = t.candidateId