I want to perform a simple query. I want to group records from a single table by one field and have the records within each group ordered by another field.

I have tried something like this without success:

SELECT Field1, Field2
FROM myTable
GROUP BY Field1
ORDER BY Field2