MySQL SELECT DISTINCT multiple columns

by

I know that the question is too old, anyway:

SELECT a, b
FROM mytable
GROUP BY a, b;

This will give your all the combinations.

More Related Contents:

  1. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  2. Count the occurrences of DISTINCT values
  3. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  4. Selecting distinct 2 columns combination in mysql
  5. get first occurrence of last changed value of a column [closed]
  6. MySQL – Rows to Columns
  7. ROW_NUMBER() in MySQL
  8. multiple query same table but in different columns mysql
  9. How can I make SQL case sensitive string comparison on MySQL?
  10. How can I temporarily disable a foreign key constraint in MySQL?
  11. How to do a batch insert in MySQL
  12. Ordering by the order of values in a SQL IN() clause
  13. Creating a “Numbers Table” in MySQL
  14. SQL Selecting from two Tables with inner join and limit [duplicate]
  15. MySQL Group by SUM
  16. Set NOW() as Default Value for datetime datatype?
  17. In SQL, how to select the top 2 rows for each group
  18. Mysql query to dynamically convert rows to columns on the basis of two columns
  19. Why do results from a SQL query not come back in the order I expect?
  20. How to generate data in MySQL?
  21. MySQL combine two columns and add into a new column
  22. How to skip certain database tables with mysqldump?
  23. MySQL error 1241: Operand should contain 1 column(s)
  24. How to set a MySQL row to READ-ONLY?
  25. Mysql: Order by like?
  26. Getting first day of the week in MySql using Week No
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. INSERT INTO Table from multiple tables
  29. Execute INSERT if table is empty?
  30. Mysql How do you create a clustered index?

Leave a Comment