3 Replies Latest reply: Mar 5, 2012 1:12 AM by jagan mohan rao appala RSS

    Can I use distinct?

      I have columns for clinicname, attendanceid and date and am trying to get average number of attendances per clinic.

      How do I use distinct to get 1 as value for clinic name per date and a count of attendances?