php - query to Ignore the repeated column in leaderboard -

i have problem database looks database structure

i want sort lboard , ignore repeated values

like required output

can me?

you use group single result 1 user , max function maximum score query this

select id, exam_id, user_id, max(lboard) `leaderb` group user_id order lboard desc