如果我没有错,你想得到两行结果。一个是最大计数男性名字,一个是最大计数女性名字。
我创建了以下示例数据库。
现在你想输出为
尝试使用以下代码
(SELECT name,SUM(count)
from BabyName
where gender='F' and year='1989'
group by name
having SUM(count) = (select MAX(name_count)
from (select SUM(count) name_count
from BabyName
where gender='F' and year='1989'
group by name ) tab))
UNION ALL
(
SELECT name,SUM(count)
from BabyName
where gender='M' and year='1989'
group by name
having SUM(count) = (select MAX(name_count)
from (select SUM(count) name_count
from BabyName
where gender='M' and year='1989'
group by name ) tab)
)