SQL distinct for 2 fields in a database

by

How about simply:

select distinct c1, c2 from t

or

select c1, c2, count(*)
from t
group by c1, c2

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. Is there any difference between GROUP BY and DISTINCT
  4. Group by minimum value in one field while selecting distinct rows
  5. How to use DISTINCT and ORDER BY in same SELECT statement?
  6. SQL to find the number of distinct values in a column
  7. Eliminating duplicate values based on only one column of the table
  8. sql query distinct with Row_Number
  9. MySQL: Select DISTINCT / UNIQUE, but return all columns?
  10. Huge performance difference when using GROUP BY vs DISTINCT
  11. Produce DISTINCT values in STRING_AGG
  12. How to select records without duplicate on just one field in SQL?
  13. Select distinct from multiple fields using sql
  14. SQL query with distinct and sum
  15. How do I create a parameterized SQL query? Why Should I?
  16. Auto Increment after delete in MySQL
  17. Update table values from another table with the same user name
  18. Using an Alias in a WHERE clause
  19. How do I delete from multiple tables using INNER JOIN in SQL server
  20. Does Foreign Key improve query performance?
  21. SQL Server convert string to datetime
  22. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  23. SQL speed up performance of insert?
  24. Error: Column does not exist
  25. How to Concatenate Numbers and Strings to Format Numbers in T-SQL?
  26. SQL server identity column values start at 0 instead of 1
  27. Rails 4 LIKE query – ActiveRecord adds quotes
  28. How do I view grants on Redshift
  29. How to Execute SQL Query without Displaying results
  30. PostgreSQL – dynamic value as table name [duplicate]

Leave a Comment