Hmmm... First: select * from table1 order by field1 asc limit 1 Last: select * from table1 order by field1 desc limit 1
----- Original Message ----- From: "Schulman, Michael" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 01, 2004 6:47 PM Subject: Time series > Hi, > > I work for a large financial instituition. We are currently evaluating > databases to store intraday stock data. These are large tables with 40 > million rows per day. We've done some initial testing with MySQL and have > been extremely impressed with its speed and ease of use. I know that it > goes agains the SQL standard but adding a FIRST,LAST aggregate function > along with some other time series functions would allow mysql to compete > with just about any timeseries database, and open up mysql to a huge market > of financial firms. I know my firm would most likely purchase it. Has > anyone developed anyhting like this as an add on? > > Thanks, > Mike > > -------------------------------------------------------------------------- ---- > This message is intended only for the personal and confidential use of the > designated recipient(s) named above. If you are not the intended recipient of > this message you are hereby notified that any review, dissemination, > distribution or copying of this message is strictly prohibited. This > communication is for information purposes only and should not be regarded as > an offer to sell or as a solicitation of an offer to buy any financial > product, an official confirmation of any transaction, or as an official > statement of Lehman Brothers. Email transmission cannot be guaranteed to be > secure or error-free. Therefore, we do not represent that this information is > complete or accurate and it should not be relied upon as such. All > information is subject to change without notice. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]