Avatar of willsherwood
willsherwood

asked on 

MySQL need to add GROUP BY State to existing query

The following query works well except when i try to add GROUP BY

    SELECT *
      FROM        tblEvents AS EVT
      WHERE        EVT.Online='1'  AND  (etc)    
      ORDER BY EVT.Date ASC, EVT.Time
        GROUP BY State

How to re format so i can aggregate for States together (groupings ordered alphabetically by State), then within each State, ordered by date

thank you!
MySQL ServerSQL

Avatar of undefined
Last Comment
willsherwood

8/22/2022 - Mon