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

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 remaining