SQL Query question

Need help with:

I have a table with columns ID and TASKNO which looks like:

TASKNO     ID
1                   JOB1
2                  JOB1
3                 JOB1
1                 JOB2
2                JOB2
1                JOB3
2                JOB3

I need to be able to select one of each ID based on the highest TASKNO

Resulting in
TASKNO ID

3              JOB1
2             JOB2
2             JOB3

Thanks,
Bob Received on Mon Jun 01 1998 - 17:01:37 CDT