retrieving latest info

[sugoi_kat]

i'm just wondering if it was possible to use SQL to retrieve the latest information.Part of the database has to retrieve the last exercise the student has completed regardless of when they completed it, in other words, user's don't specify a date.The date of when this exercise is completed is going to be placed on the form along with the name of the exercise.

[justsomeguy]

i'm just wondering if it was possible to use SQL to retrieve the latest information.Part of the database has to retrieve the last exercise the student has completed regardless of when they completed it, in other words, user's don't specify a date.The date of when this exercise is completed is going to be placed on the form along with the name of the exercise.

Just get all records (or limit 1) and order them descending by date. The first record will be the most recent.

[pulpfiction]

Hi, You can also check for the higest value of the Identity Column for that student. this will be the last record added for that student.

[muhammadadilmalik]

Hi, You can also check for the higest value of the Identity Column for that student. this will be the last record added for that student.

<{POST_SNAPBACK}>

all the two solution are good but i think you have to send student name or login name in where clause also other wise it will give you general results