SqlQuery.GroupBy method (1 of 2)
namespace: Serenity.Data assembly: Serenity.Net.Data
Adds a field name or an SQL expression to the GROUP BY clause.
public SqlQuery GroupBy(string expression)
| parameter | description |
|---|---|
| expression | Array of fields or expressions. |
Return Value
The query itself.
See Also
- class SqlQuery
SqlQuery.GroupBy method (2 of 2)
namespace: Serenity.Data assembly: Serenity.Net.Data
Adds a field of a given table alias to the GROUP BY clause.
public SqlQuery GroupBy(IAlias alias, string fieldName)
| parameter | description |
|---|---|
| alias | A table alias that will be prepended to the field name with "." between |
| fieldName | A field name of the aliased table. |
Return Value
The query itself.