How to select records without duplicate on just one field in SQL?

by

Try this:

SELECT MIN(id) AS id, title
FROM tbl_countries
GROUP BY title

More Related Contents:

  1. How do I (or can I) SELECT DISTINCT on multiple columns?
  2. SQL/mysql – Select distinct/UNIQUE but return all columns?
  3. MySQL: Select DISTINCT / UNIQUE, but return all columns?
  4. Select distinct from multiple fields using sql
  5. Whats wrong in this sql query? It throws error [closed]
  6. SQL update from one Table to another based on a ID match
  7. Group by minimum value in one field while selecting distinct rows
  8. SQL SELECT WHERE field contains words
  9. JOIN two SELECT statement results
  10. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  11. How to use DISTINCT and ORDER BY in same SELECT statement?
  12. SQL SELECT speed int vs varchar
  13. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  14. MySQL remove duplicates from big database quick
  15. Return a value if no record is found
  16. How to delete from select in MySQL?
  17. SQL to find the number of distinct values in a column
  18. How can I select from list of values in Oracle
  19. sql query distinct with Row_Number
  20. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  21. SQL: how to select a single id (“row”) that meets multiple criteria from a single column
  22. SQL SELECT from multiple tables
  23. Can select * usage ever be justified?
  24. Left Join without duplicate rows from left table
  25. SQL: Two select statements in one query
  26. Check if two “select”s are equivalent
  27. SQL: Select rows with a column value that occurs at least N times?
  28. SQL query with distinct and sum
  29. Combine Two Tables in Select (SQL Server 2008)
  30. How to bulk insert only new rows in PostreSQL

Leave a Comment