When you need to group resulting data, you must specify the field you want to group on in GROUP BY clause. When you want to sort data by a field, you must include the field in the ORDER BY list. In dbForge Query Builder, the interface for this clauses is approximately the same. The only difference is that the ORDER BY tab has the Change Order button that you can use to alter sorting direction.
To include fields in ORDER BY clause, switch to the corresponding tab of the tabbed editor and perform the following steps:
If you want to exclude a field from the list, select it and click the left arrow button.