Dear Santa Jon,
What I want for Christmas is for prescriptions to have lists of sigs and dispense quantities to be listed in descending order of frequency used in the past. I want the program to learn from prior choices.
I imagine you might have to deal with the NewCrop elves on this, so I wanted to give you plenty of time. To make it easier, I do not care whether the frequency order is from my use or from all the physicians in the universe that use NewCrop.
To be helpful, the SQL for this is:
SELECT tableA.field1
FROM tableA
GROUP BY tableA.field1
ORDER BY Count(tableA.field1) DESC;
Hopefully,
Trying to be a good boy but not doing very well
