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:
It returns every record. Can anyone tell me how to get it to only return the first instanceCode:SELECT DISTINCT Course.COURSE_PRODUCT_ID, Course.COURSE_NAME FROM Course ORDER BY Course.COURSE_NAME
of each COURSE_PRODUCT_ID?
Thanks in advance