:thumbsup: Super, It's now in order ! ;) Thanks

:thumbsup: Super, It's working ;) Thanks

Correct but the result with the extract below is not correct. MAX(TheDate), Type, Value 2011/08/11 , T1 , 10 2011/08/17 , T1 , 12 2011/09/25 , T1 , 11 2011/08/11 , T2 , 15 2011/10/10 , T3 , 15 ... The result is : MAX(TheDate), Type, Value 2011/08/11 , T1 , 10 :confused: 2011/09/25 , T1 , 11 2011/08/11 , T2 , 15 2011/08/15 , T2 , 10 ... Because select MAX(TheDate) from Table group by Type return 2011/09/25 (for T1) 2011/08/11 (for T2) 2011/10/10 (for T3)

OK, but you select the max date and not the max date per type I have several types and I shearch the last value for each type and not the max date per type

Thanks for the idea, but it's not enought because the values are diffrent. I receive in this case : MAX(TheDate), Type, Value 2011/08/11 , T1 , 10 2011/08/17 , T1 , 12 2011/09/25 , T1 , 11 2011/08/15 , T2 , 10 ... And I only need the last value for T1, T2, ... ! Mike

I have as table like TheDate Type Value I need to retreive the last value for each type. I try a SQL command like SELECT MAX(TheDate), Type, Value from MyTable GROUP BY Type But I receive an error : Erreur SQL : ORA-00979: not a GROUP BY expression 00979. 00000 - "not a GROUP BY expression" Do you have any idea ?