Hi
Using Firebird 1.5

I have table tCurrencyHistory

ID DATE CURRENCY RATE
===========================================
1 01.01.05 USD 1.51
2 01.01.05 EUR 1.96
3 02.01.05 USD 1.50

i need to select only the last currency rates for each currency:
result:
ID DATE CURRENCY RATE
===========================================
2 01.01.05 EUR 1.96
3 02.01.05 USD 1.50

Please, give me an example how to do this, because i try with
Max(DATE) but it doesn't work because of Group By clause for RATE
column - it return each value

Thanks in advance!