Choose the Minimum Value in Query

Question

I have viewed many Q&A's regarding selecting MIN value from column names i.e find min and max but my problem is not solved.

SELECT MIN(column1  + (5 * 24 * 60 * 60) AS deadline1, column2 +(1 * 24 * 60 * 60) AS deadline2) AS deadline FROM table_name

Showing error code Error Code : 1064

How can I select the minimum value from both values? any idea plz?

Please have a look at http://stackoverflow.com/questions/368351/whats-the-best-way-to-select-the-minimum-value-from-multiple-columns — Chetter Hummin, Apr 04 '13 at 09:22
@Barmar True, but MySQL has a case structure as well which can be used. A good reference is at http://dev.mysql.com/doc/refman/5.0/en/case.html — Chetter Hummin, Apr 04 '13 at 09:25
@ChetterHummin: actually I was using the wrong function here, its solution was to use the least function. — Suleman Ahmad, Apr 04 '13 at 09:28

score 4 · Accepted Answer · answered Apr 04 '13 at 09:24

4

MySQL uses MIN only as an aggregate function. To select the minimum of several expressions, you have to use LEAST:

SELECT LEAST(column1  + (5 * 24 * 60 * 60), column2 +(1 * 24 * 60 * 60)) AS deadline FROM table_name

answered Apr 04 '13 at 09:24

Barmar

1 Answers1