a.emp_no,
max(a.rt) t
from(
    select *,
    row_number()over(partition by emp_no order by salary) rt from salaries) a
group by 1
having t >15