Eine Einführung in

SQL

How can I get the Lastest record from SQL

MySQL
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
A03    
....
I want to get " where is the keep place for all balance by now?

Answer

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.