Eine Einführung in


How can I get the Lastest record from SQL

I have a table like this:
balance    keepplace     startdate
A01        floor 1       2002-10-10
A01        BBB           2001-08-08
A02        222           2002-07-08
A02        111           2000-01-01
I want to get " where is the keep place for all balance by now?


Use a sub-select to get the last date - and make that match the original...

Specific to MySQL
Sadly MySQL does not support nested SELECT statements nor does it allow views and so I don't see how this can be accomplished without copying the last date to another tables.