How to select records without duplicate on just one field in SQL? June 9, 2023 by Tarik Try this: SELECT MIN(id) AS id, title FROM tbl_countries GROUP BY title