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

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 instanceof each COURSE_PRODUCT_ID?

Thanks in advance

Dave

r937
—
2012-10-22T14:17:31Z —
#2

davecheet said:

Can anyone tell me how to get it to only return the first instanceof each COURSE_PRODUCT_ID?

something is seriously amiss

if you run a DISTINCT on both course_product_id and course_name, and it "doesn't work" to produce only one instance of course_product_id, then this implies that there are course_product_id values that have multiple different course_name values

your data is b0rked

KyleWolfe
—
2012-10-22T14:34:08Z —
#3

davecheet said:

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: