SQL Question

I have the SQL, below. I actually only want to return the first value for each group, though. How can I change my SQL to accomplish that? Basically, for each pat_id, patient_labs_column_name, I want the most recent date with its associated result. Truly appreciate any help! Gigi

SELECT PAT_ID, MAX(PATIENT_LABS_COLUMN_NAME) AS LAB_TYPE, MAX(DATE_OF_LAB) AS MR_DATE, MAX(MISC_LAB_VALUE) AS RESULT FROM MISC_LABS, MISC_LABS_CODES WHERE (MISC_LABS.MISC_LAB_CODE_ID = MISC_LABS_CODES.MISC_LAB_CODE_ID) AND (MISC_LABS_CODES.PATIENT_LABS_COLUMN_NAME IS NOT NULL) AND (PAT_ID = 13964) GROUP BY PAT_ID, PATIENT_LABS_COLUMN_NAME, DATE_OF_LAB ORDER BY PAT_ID, PATIENT_LABS_COLUMN_NAME, DATE_OF_LAB DESC Received on Fri Oct 04 2002 - 18:20:09 CEST