2uzhan.com
Advertisement
Now Place:2uzhan.com » Interesting querry with date

Interesting querry with date

MySQL @ June 17, 2008   Views:0

Lets say the table had DATETIME date and DECIMAL close.

What do I add to this to select the close at MIN(date)?

SELECT MIN(close) AS 'minimum', MAX(close) As 'maximum', FROM symbolTable WHERE date BETWEEN '2008-05-14 12:59:04' AND '2008-05-14 13:29:03' ORDER BY date";

--------------Solutions-------------

In this example, is MIN(close) >= '2008-05-14 12:59:04', or could it be sometime further in the past?

Tags:
© 2018 2uzhan.com Contact