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:
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
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
What do you define as the first instance? Last course entered? First of the day?
This topic is now closed. New replies are no longer allowed.