system — 2012-10-22T09:42:27-04:00 — #1
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
r937 — 2012-10-22T10:17:31-04:00 — #2
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-22T10:34:08-04:00 — #3
What do you define as the first instance? Last course entered? First of the day?