SQL查找人员条目的狗最多

2021-12-24 00:00:00 sql oracle plsql

人(身份证，狗)

如何找到狗最多的人

select *
from person p1
where p1.id in (
    select p2.id
    from person p2
    where p1.id = p2.id
    having count(dogs > (
        select p3.id ...etc

我是在正确的轨道上还是这行不通?谢谢观看

am I on the right track or will this not work? thanks for taking a look

推荐答案

这个怎么样?

select *
from person
where dogs = (select max(dogs) from person)

可能不是最有效的方法，但这会给你一个(或多个)狗数量最多的人.如果你只想要其中之一，你可以这样做:

Probably not the most efficient way, but that will give you the person (or persons) that have the greatest dog count. If you just want one of them, you can do this:

select top 1 
from person
order by dogs desc

相关文章