How Do I ... : Work with databases : Use the SELECT Details window : Specify a GROUP BY clause
Specify a GROUP BY clause
Specify a nested SELECT statementSpecify a nested SELECT statementNo tip for this topicNo example for this topicSpecify a HAVING clauseSpecify a HAVING clause
To specify the GROUP BY clause, do the following:
1. Select the columns you want to include in the GROUP BY clause.
2. Specify the sequence you want the columns to be in the GROUP BY clause.
3. Select Apply.
To move a column before some other one in the GROUP BY sequence, use the GROUP BY sequence pop-up menu:
1. Select the column you want to move.
2. From the GROUP BY sequence pop-up menu, select Move before and then the column you want the one you selected in the list to be moved before.
To move a column after some other one in the GROUP BY sequence, use the GROUP BY sequence pop-up menu:
1. Select the column you want to move.
2. From the GROUP BY sequence pop-up menu, select Move after and then the column you want the one you selected in the list to be moved after.
Last modified date: 08/13/2019