Use limit with where clause in in mysql
You need to use order by credits desc (descending) in order to get the 3 highest credits so the sql would be:

select * from `records` 
where `type` = 'my'
order by credits desc
limit 3;