MySQL How I can do it?

[Anon]

I have a DB

field1 | field2 | date
jim | 32 |2000-08-10
jim | 46 |2000-09-12
jim | 41 |2000-10-01
Len | 29 |2000-09-10
Len | 27 |2000-05-15
Sam | 24 |2000-03-10
Sam | 49 |2000-05-08

Sam | 81 |2000-07-06

I want to know (for each one in Field1) the value in Field2 corresponding to the recently Date.
Result I Want:
jim | 41 |2000-10-01
Len | 29 |2000-09-10

Sam | 81 |2000-07-06

How I can do it?

I write this but it doesn't work right.
select field2 from TAB group by field2 having max(date)

[Anon]

I dont know exactly what you are diong but this document is the best sql tutorial on the net and is a very good reference for newies such as myself.

http://w3.one.net/~jhoffman/sqltut.htm

[Anon]

try this maybe...
SELECT field1, field2, max(date) AS maxDate FROM TAB ORDER BY Field1

Field1|Field2 |maxDate
jim | 41 |2000-10-01
Len | 29 |2000-09-10
Sam | 81 |2000-07-06