SELECT
    group, somedata
  FROM
    table
  ORDER BY
    group, somedata