Forum Discussion
Count Distinct after dropping duplicates
Scenario: A student_one can enroll in fall as full-time student and enroll in spring as part-time but when you report the total enrollment, he/she should be counted only once. A student_2 can enroll ...
Hi bkunwor ,
Based on the description, not certain how did you define the full-time/part-time student in spring/fall and what did the table look like.
Perhaps you can consider sharing a sample data table or more details about this thread for further. Sample data and expected output would help tremendously.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.