请尝试以下操作：

select id_desireCollage
from
(
  select d.*,
    row_number() over (partition by id_student order by ID) as rn
  from desires d
) T
where rn > 5
group by id_desireCollage
order by count(*) desc
fetch first 1 row with ties

如果你不想使用行号函数（正如你所评论的），你可以尝试下面的**-假设ID列中没有间隙**：

select id_desireCollage
from desires d
where id >= 
  (
    select min(id)+5
    from desires t 
    where t.id_student = d.id_student
  )
group by id_desireCollage
order by count(*) desc
fetch first 1 row with ties

See demo
正如@MatBailie所建议的，如果您的意思是 * common *，即所有学生都选择了id_desireCollage值，则您可以使用以下命令：

select id_desireCollage
from desires d
where id >= 
  (
    select min(id)+5
    from desires t 
    where t.id_student = d.id_student
  )
group by id_desireCollage
having count(*)=
(
  select count(distinct id_student)
  from desires 
)