I thought I got this right but it is not counting the person_id category
It returns them each on a different row instead of returning them with one row and the number of times they repeated. I must have something wrong, just can't seem to find it
thank you
SELECT CRC_screening_pt_reminder_at_visit.person_id, Count(CRC_screening_pt_reminder_at_visit.person_id) AS ReminderCount, CRC_screening_pt_reminder_at_visit.modify_timestamp, CRC_screening_pt_reminder_at_visit.colon_cancer
FROM CRC_screening_pt_reminder_at_visit
GROUP BY CRC_screening_pt_reminder_at_visit.person_id, CRC_screening_pt_reminder_at_visit.modify_timestamp, CRC_screening_pt_reminder_at_visit.colon_cancer;
Patty
__._,_.___
Posted by: pattykf@cox.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar