Online Documentation for SQL Manager for MySQL

Sort and group data


In order to sort data, do the following:

  1. Open data at the Data or Results tab.
  2. Choose the column by which you need to sort data and click the column title.
  3. If the column was not sorted, the first click will sort it in the ascending order and the second one - in the descending order.

Note: To cancel the sorting, open the context menu by right-clicking the necessary column and choose the Clear Sorting item, or press the Ctrl button and click the column title.

 

To enable grouping, drag the column title to the special grouping bar above the grid.

 

HowTo - Data View - Grid View - Grouping data by two columns_Small

 

 

Note: To disable grouping, drag the column title from the group bar back to the table.