Group By & Order By

[Amyeech]

Can I use these two conditions (GROUP BY & ORDER BY) in one single command?

SELECT ID_No,SUM(Freq) FROM FaultDatabase GROUP BY ID_No and ORDER BY Freq

Sorry for this weird question. I'm new to SQL.

Thank you in advance.

[VictorN]

try this:
SELECT ID_No,SUM(Freq) FROM FaultDatabase GROUP BY ID_No ORDER BY SUM(Freq)