sql question

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

If subqueries are new, here's an introduction:
http://allenbrowne.com/subquery-01.html

 

[msnews.microsoft.com]

Hi all

I have a table like this :

employee_name,date,income
e1,01/01/2008,100
e2,01/01/2008,110
e3,01/01/2008,120
e1,02/01/2008,80
e2,02/01/2008,210
e3,02/01/2008,90
e1,03/01/2008,110
e2,03/01/2008,105
e3,03/01/2008,90
..
..
..

I need a query that will return for each employee the date that he did the
max income
e.g.:
e1,03/01/2008,110
e2,02/01/2008,210
e3,01/01/2008,120

If it helps there is an ID (autonumber) for each row...

TIA
Guy Cohen