public void ColumnsAggregations1()
{
ColumnsListAggregation c = new ColumnsListAggregation(global::SqlBuilder.Format.MsSQL);
c.FuncCount("all");
c.FuncMax("cnt", "max_cnt");
string result = c.GetSql();
string sql = "COUNT([all]), MAX([cnt]) as 'max_cnt'";
Assert.AreEqual(sql, result);
}
public void ColumnsAggregations1()
{
SqlBuilder.DefaultFormatter = FormatterLibrary.MsSql;
ColumnsListAggregation c = new ColumnsListAggregation(SqlBuilder.DefaultFormatter);
c.FuncCount("all");
c.FuncMax("cnt", "max_cnt");
string result = c.GetSql();
string sql = "COUNT([all]), MAX([cnt]) as 'max_cnt'";
Assert.AreEqual(sql, result);
}
public void ColumnsAggregations1()
{
SuperSql.DefaultFormatter = FormatterLibrary.MsSql;
var c = new ColumnsListAggregation(SuperSql.DefaultFormatter);
c.FuncCount("all");
c.FuncMax("cnt", "max_cnt");
var result = c.GetSql();
var sql = "COUNT([all]), MAX([cnt]) as 'max_cnt'";
Assert.Equal(sql, result);
}
