'Declaration Public ReadOnly Property GroupBy As SelectColumnCollection
public SelectColumnCollection GroupBy {get;}
'Declaration Public ReadOnly Property GroupBy As SelectColumnCollection
public SelectColumnCollection GroupBy {get;}
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());