MYSQL select DISTINCT values in two columns

by

How about using GROUP BY?

SELECT foo,bar FROM my_table GROUP BY foo,bar

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. SQL split values to multiple rows
  3. Get records with max value for each group of grouped SQL results
  4. How to populate a table with a range of dates?
  5. MYSQL OR vs IN performance
  6. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  7. MySQL Cannot Add Foreign Key Constraint
  8. Grouping into interval of 5 minutes within a time range
  9. How to find gaps in sequential numbering in mysql?
  10. Convert timestamp to date in MySQL query
  11. Update a column value, replacing part of a string
  12. MySQL: View with Subquery in the FROM Clause Limitation
  13. MySql export schema without data
  14. mysql dynamic query in stored procedure
  15. MySQL combine two columns into one column
  16. MySQL Insert Into from one Database in another
  17. MySQL: LIMIT by a percentage of the amount of records?
  18. limiting the rows to where the sum a column equals a certain value in MySQL
  19. MySQL multiple columns in IN clause
  20. MySQL Inner Join Query Multiple Tables
  21. How to select one row randomly taking into account a weight?
  22. How to select column names dynamically in mySQL
  23. Select a column with a keyword name
  24. MySQL Stored Procedures not working with SELECT (basic question)
  25. ERROR 1148: The used command is not allowed with this MySQL version
  26. Use Composite Primary Key as Foreign Key
  27. MySQL Select minimum/maximum among two (or more) given values
  28. How to select data where a field has a min value in MySQL?
  29. How do you force mysql LIKE to be case sensitive? [duplicate]
  30. In what order are MySQL JOINs evaluated?

Leave a Comment