ordering groups

[Anon]

how do you select fields from a table and group them and then order the groups
if im not mistaken you cant use order by and group by in the same select

[Anon]

select * from accessoption group by
submodule order by submodule

can.

or

select DISTINCT submodule from accessoption order by submodule

[[deleted]]

Note:

the first statement is not a proper SQL statement. You can only select columns by which you group, or on which you use aggregates.

SELECT MAX(field) FROM table GROUP BY otherfield;

is correct,

SELECT field FROM table GROUP BY othertable

is not.

Yes MySQL will accept both, but that is because MySQL is convenient rather than good 🙂