Contents Index Where tab Having tab

SQL Anywhere Studio Help
  Query Editor Help

Group By tab


Use this tab if you want to group rows in the result set.

Dialog components 
About GROUP BY conditions 

You can group by columns, alias names, or functions. The result of the query contains one row for each distinct set of values in the named columns, aliases, or functions. All null-containing rows are treated as a single set. The resulting rows are often referred to as groups since there is one row in the result for each group of rows from the table list. Aggregate functions can then be applied to these groups to get meaningful results.

When GROUP BY is used, the Columns tab, Having tab, and Order By tab must not reference any identifier that is not named in the Group By tab. The exception is that the Columns tab and Having tab may contain aggregate functions.

More information 

Contents Index Where tab Having tab