selecting unique values from a column

by

Use the DISTINCT operator in MySQL:

SELECT DISTINCT(Date) AS Date FROM buy ORDER BY Date DESC;

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. How can create Database using url or other method [duplicate]
  3. Problame with files on SQL
  4. Im trying to create some temporary tables in mysql using php
  5. How can I prevent SQL injection in PHP?
  6. SQL injection that gets around mysql_real_escape_string()
  7. How to include a PHP variable inside a MySQL statement
  8. How to apply bindValue method in LIMIT clause?
  9. SELECT COUNT(*) AS count – How to use this count
  10. How to resolve ambiguous column names when retrieving results?
  11. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  12. Use bound parameter multiple times
  13. I cannot get my login form to connect interact properly with mySQL database [closed]
  14. mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]
  15. Increment value in MySQL update query
  16. Create a dynamic mysql query using php variables
  17. How to separate DATE and TIME from DATETIME in MySQL?
  18. Do SQL connections opened with PDO in PHP have to be closed
  19. How to convert ISO8601 to Date format in php
  20. MySQL skipping first row
  21. How to reverse order output of a MySQL query
  22. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  23. How to generate unique id in MySQL?
  24. Fatal error: Call to a member function query() on null
  25. How would I implement a simple site search with php and mySQL?
  26. Do I have to use mysql_real_escape_string if I bind parameters?
  27. SELECT row by DATEPART()
  28. UNION syntax in Cakephp
  29. How do i search from serialize field in mysql database?
  30. PDO and MySQL ‘between’

Leave a Comment