Contains list of columns used in the GROUP BY clause of the current
SelectStatement object.
Property Value
A
SelectColumnCollection that represents list of columns used in the GROUP BY clause.
The following example demonstrates how to use the
GroupBy property.
MySqlSelectStatement stmt = new MySqlSelectStatement();
SelectColumn jobName = new SelectColumn("JOB");
stmt.Columns.Add(jobName);
stmt.Columns.Add(new SelectColumn("AVG(SAL)"));
stmt.Tables.Add(new SelectTable("emp"));
stmt.GroupBy.Add(jobName);
stmt.Having = "AVG(SAL) > 1000";
//select JOB,AVG(SAL) from emp group by JOB having AVG(SAL) > 1000
MySqlCommand command = new MySqlCommand(stmt.ToString());