How to select a row based on the maximum value of a column, when ties are expected
select subscriber, date_column, time_column, value from (
  select 
    subscriber, date_column, time_column, value,
    rank() over (partition by subscriber order by value desc, time_column) as r
  from mytab
) where r = 1
and subscriber = 'ccc';