LeetCode--574. 当选者

建表

create table candidate ( id int, Name char ); create table vote ( id int, CandidateId int ); insert into candidate values(1, 'A'); insert into candidate values(2, 'B'); insert into candidate values(3, 'C'); insert into candidate values(4, 'D'); insert into candidate values(5, 'E'); insert into vote values(1, 2); insert into vote values(2, 4); insert into vote values(4, 3); insert into vote values(1, 2); insert into vote values(5, 5);

第一种思路

select `Name` from candidate c, vote v where c.id = v.candidateId group by c.Name order by count(v.id) desc limit 1

第二种思路

select `Name` from candidate c, (select candidateId, count(candidateId) from vote GROUP BY candidateId limit 1) tmp where c.id = tmp.candidateId