MySQL Select minimum/maximum among two (or more) given values

by

You can use LEAST and GREATEST function to achieve it.

SELECT
    GREATEST(A.date0, B.date0) AS date0,
    LEAST(A.date1, B.date1) AS date1
FROM A, B
WHERE B.x = A.x

Both are described here http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. INSERT INTO SELECT statement with more columns which is not in another table
  3. multiple query same table but in different columns mysql
  4. How can I make SQL case sensitive string comparison on MySQL?
  5. 1052: Column ‘id’ in field list is ambiguous
  6. How can I temporarily disable a foreign key constraint in MySQL?
  7. How to do a batch insert in MySQL
  8. Count the occurrences of DISTINCT values
  9. Creating a “Numbers Table” in MySQL
  10. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  11. Cumulative sum over a set of rows in mysql
  12. Set NOW() as Default Value for datetime datatype?
  13. In SQL, how to select the top 2 rows for each group
  14. Add Auto-Increment ID to existing table?
  15. MySQL SELECT DISTINCT multiple columns
  16. SQL DELETE with JOIN another table for WHERE condition
  17. mysql trigger stored trigger is already used by statement which invoked stored trigger
  18. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  19. Using group by on two fields and count in SQL
  20. mysql update query with sub query
  21. What is the difference between the backtick and the square bracket in SQL statements?
  22. MySQL CONCAT returns NULL if any field contain NULL
  23. Integrity constraint violation: 1452 Cannot add or update a child row:
  24. How to insert a file in MySQL database?
  25. What does SQL Select symbol || mean?
  26. Using DISTINCT and COUNT together in a MySQL Query
  27. How to check if field is null or empty in MySQL?
  28. MySQL OPTIMIZE all tables?
  29. Strip last two characters of a column in MySQL
  30. Deleting a row based on the max value

Leave a Comment