SELECT f.* from(SELECT country, min(id) as MinId FROM mytable GROUP BY country) as X INNER JOIN mytable as f ON f.country = x.country AND f.id = x.MinId order BY f.country
To get ID of Selected RadioButton using jQuery (change nameOfRadio to actual radio name) var id = $("input:radio[name=nameOfRadio ]:checked").attr('id');