SQLzoo.net

How can I get the Lastest record from SQL

Oracle
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 Oracle
none

Related links:

  • DATES