Limiting the results of a mysql query to the first matches only -

i have following mysql query collect prices various domain names.

select tdp.extension, tp.msetupfee tblpricing tp inner join tbldomainpricing tdp on tdp.id = tp.relid  tp.type = 'domainregister' , tp.msetupfee > 0 

the problem when outputs data screen using last record returned. want limit returning first value per domain type.

i have set fiddle here http://sqlfiddle.com/#!9/59aeac/1 , can see .com returns 11.35 9.23. want 11.35 tried adding limit 1 made return first domain only. cleanest solution issue?

add group tdp.idto query - should help...