can you use the group by clause twice in an sql statement?

sql = "SELECT PatientName as 'Patient Name', PatientID as 'Patient
ID', PatientDOB as 'Birth Date', StudyDescription as 'Study
Description', SeriesDate as 'Study Date', COUNT(DISTINCT SeriesUID) AS
'Series In Study' FROM ImageTable WHERE CTPName LIKE '" + ctpn + "'
AND SeriesDate >= " + sds + " AND SeriesDate <= " + eds + " GROUP BY
StudyUID;"

before the ; can I add another 'group by somecolumn'

?

On Oct 29, 2:59*pm, SpreadTooThin <bjobrie... (AT) gmail (DOT) com> wrote:
GROUP BY accepts a comma-separated list of columns, like the field
list or the order by cause.