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 has the same low recorded, so I want the first occurance. I tried SELECT min(tmin) FROM quotes WHERE tag='CSCO' HAVING min(low); which at least didn't have syntax errors, but alas did not produce a result. A few pointers? TIA --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
