Re: Data series selection help

2002-03-07 Thread DL Neil
Hi "MySQL", > I record some stock data into MySQL, I'm looking for the correct > syntax for a SELECT statement. > > SELECT min(Tmin) FROM quotes WHERE low=min(low) > > In short, I want the time of the occurance of the low for the day, > Tmin is time column. Once the low is achieved, all the rema

Data series selection help

2002-03-07 Thread MySQL
I record some stock data into MySQL, I'm looking for the correct syntax for a SELECT statement. SELECT min(Tmin) FROM quotes WHERE low=min(low) In short, I want the time of the occurance of the low for the day, Tmin is time column. Once the low is achieved, all the remaining data for the day ha