how can I filter record 60122839991 with the highest score 95.3758 and return as below without duplicate phone number
Advertisement
Answer
Use distinct on
:
x
select distinct on (mobile_number) t.*
from mytable t
order by mobile_number, score desc