Sorry, I meant to say "I've tried the subquery", not the substring, on 4.1, and that's probably what we'll use in the future.
select date, value, type from A a1 where value = (select max(a2.value) from A a2 where a1.type = a2.type); Ana --- Ana Holzbach <[EMAIL PROTECTED]> wrote: > > Hi Roger, > > Thanks for the pointer. > > CONCAT would be a nightmare to maintain, especially > with data where the values can have all sorts of > ranges, and where we could just as well be looking > for > the value corresponding to the latest (or earliest) > date instead. It would just create too many cases to > pad, parse, etc. > > However, I tried the substring on 4.1 and it's a > reasonable alternative. Fortunately, by the time we > need this functionality 4.1 will probably be stable. > > Ana ===== Ana Holzbach [EMAIL PROTECTED] __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
