Lectures presented by all the students during the last year has been stored in a talbe named: studentlectures, with these fields : ID, studentname, lecturesubject, lecturedate
For example:
1, john, mathematics, 2/3/2012
2, jack, chemistry, 10/3/2012 ,
3,john, engineering, 15/3/2012
4,jack ,chemisty,20/3/2012
5,john,politics,30/3/2012
6,john,engineering, 15/4/2012
7,jack,politics,15/4/2012
We want a query to show the latest record for each student with a specific lecture. For the above example the result will be:
1, john, mathematics, 2/3/2012
4, jack , chemisty,20/3/2012
5,john, politics,30/3/2012
6, john, engineering, 15/4/2012
7, jack,politics,15/4/2012
Previous subject records by each student are not shown, and only the latest one is shown.
Thank you
For example:
1, john, mathematics, 2/3/2012
2, jack, chemistry, 10/3/2012 ,
3,john, engineering, 15/3/2012
4,jack ,chemisty,20/3/2012
5,john,politics,30/3/2012
6,john,engineering, 15/4/2012
7,jack,politics,15/4/2012
We want a query to show the latest record for each student with a specific lecture. For the above example the result will be:
1, john, mathematics, 2/3/2012
4, jack , chemisty,20/3/2012
5,john, politics,30/3/2012
6, john, engineering, 15/4/2012
7, jack,politics,15/4/2012
Previous subject records by each student are not shown, and only the latest one is shown.
Thank you