HI folks,

I am working in MSSQL and trying to pull out

COURSE_PRODUCT_ID and COURSE_NAME but only the in the first instance of each COURSE_PRODUCT_ID.
This doesn't work:

Code:
SELECT DISTINCT
Course.COURSE_PRODUCT_ID,
Course.COURSE_NAME
FROM Course
ORDER BY Course.COURSE_NAME
It returns every record. Can anyone tell me how to get it to only return the first instance
of each COURSE_PRODUCT_ID?

Thanks in advance

Dave