lundi 11 avril 2016

Count when there are 6 or more unique occurrences in a column then in a new column have a string that identifies it

I have a table with patients, their services, date of services, ect... If a patient has 6+ unique services in a month then in my select statement I want a new column to have the word "Full Month" in it.

Aucun commentaire:

Enregistrer un commentaire