How to select unique records by SQL

by

With the distinct keyword with single and multiple column names, you get distinct records:

SELECT DISTINCT column 1, column 2, ...
FROM table_name;

More Related Contents:

  1. SQL Data models
  2. How to randomly select rows in SQL?
  3. What’s the difference between TRUNCATE and DELETE in SQL
  4. SQL best practice to deal with default sort order
  5. Can table columns with a Foreign Key be NULL?
  6. Deleting duplicate rows from sqlite database
  7. Decision between storing lookup table id’s or pure data
  8. How Can I use “Date” Datatype in sql server?
  9. How to replace a string in a SQL Server Table Column
  10. How many rows in a database are TOO MANY?
  11. Primary key or Unique index?
  12. How to get a list of column names on Sqlite3 database?
  13. How to run a stored procedure in sql server every hour?
  14. Composite Primary key vs additional “ID” column?
  15. Questions every good Database/SQL developer should be able to answer [closed]
  16. Why do you create a View in a database?
  17. Logging ALL Queries on a SQL Server 2008 Express Database?
  18. Best database field type for a URL
  19. Max length for client ip address [duplicate]
  20. MySQL – how to front pad zip code with “0”?
  21. How can I implement SQL INTERSECT and MINUS operations in MS Access
  22. Postgres Error: More than one row returned by a subquery used as an expression
  23. Does ‘Select’ always order by primary key?
  24. How do I create and query linked database servers in SQL Server?
  25. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  26. Should I commit or rollback a read transaction?
  27. Why are foreign keys more used in theory than in practice?
  28. Relational Data Model for Double-Entry Accounting
  29. Do conditional INSERT with SQL?
  30. What is difference between foreign key and reference key?

Leave a Comment