ESQL function Statistic class
| Avg
Average |
Mycontext context = new Mycontext ();
String esql = "Select Value AVG" (it. Itemvalue) from mycontext.dbitemlist as it ";
objectquery<int> query = context. Createquery<int> (ESQL);
foreach (int n in query)
{
Console.WriteLine (n);
}
/* Print:
3
*/ |
| Bigcount
Number (long) |
Mycontext context = new Mycontext ();
String esql = "Select Value Bigcount" (it. Itemvalue) from mycontext.dbitemlist as it ";
objectquery<long> query = context. Createquery<long> (ESQL);
foreach (long n in query)
{
Console.WriteLine (n);
}
/* Print:
15
*/ |
| Count
Number (int) |
Mycontext context = new Mycontext ();
String esql = "Select Value Count" (it. Itemvalue) from mycontext.dbitemlist as it ";
objectquery<int> query = context. Createquery<int> (ESQL);
foreach (int n in query)
{
Console.WriteLine (n);
}
/* Print:
15
*/ |
| Max
Maximum Value |
Mycontext context = new Mycontext ();
String esql = "Select Value Max" (it. Itemvalue) from mycontext.dbitemlist as it ";
objectquery<int> query = context. Createquery<int> (ESQL);
foreach (int n in query)
{
Console.WriteLine (n);
}
/* Print:
6
*/ |
| Min
Minimum value |
Mycontext context = new Mycontext ();
String esql = "Select Value Min" (it. Itemvalue) from mycontext.dbitemlist as it ";
objectquery<int> query = context. Createquery<int> (ESQL);
foreach (int n in query)
{
Console.WriteLine (n);
}
/* Print:
1
*/ |
| Sum
Total |
Mycontext context = new Mycontext ();
String esql = "Select Value Sum" (it. Itemvalue) from mycontext.dbitemlist as it ";
objectquery<int> query = context. Createquery<int> (ESQL);
foreach (int n in query)
{
Console.WriteLine (n);
}
/* Print:
54
*/ |