[TOJluK]

На оракле работает ))
Попробуй так:

Код:

select executioner_id
  from "appointment(procedures)"
 having count(executioner_id) =
       (select max(count(executioner_id))
          from "appointment(procedures)"
         group by executioner_id)