Common use of GROUP BY Clause in Contracts

GROUP BY. The condition is added to the GROUP BY tab. Use the up arrow and down arrow buttons to change the order of fields. On the HAVING tab, you can filter summarized data or grouped data. Select the identifiers, operators, aggregate or enter expressions to include in the condition. Use the up arrow and down arrow buttons to change the order of conditions. The pop-up menu options of the HAVING tab: Toggle Negator Reverse the meaning of the condition. Insert Add a condition. Insert Custom Add a custom condition. Insert Bracket Add a pair of parentheses. Remove Remove the condition. Group with Bracket Add parentheses to group the selected conditions. Ungroup Remove the parentheses. You can set the way of sorting records by right-clicking a field on the Diagram pane and selecting Add Field To -> ORDER BY -> ASC or DESC. The condition will be added to the ORDER BY tab. On the LIMIT tab, you can limit your view results to those that fall within a specified range.