How to select records without duplicate on just one field in SQL?
Solution 1:
Try this:
SELECT MIN(id) AS id, title
FROM tbl_countries
GROUP BY title
Solution 2:
DISTINCT is the keyword
For me your query is correct
Just try to do this first
SELECT DISTINCT title,id FROM tbl_countries
Later on you can try with order by.