modified to accept hostname and connect to the network
[csql.git] / test / sql / Aggregate / exp.test001.ksh
blobc0075ca9a89db0cfae486e3c1f7da92968a911e0
1 select count(f1) from nonExistTab :
2 Statement prepare failed with error -5
3 select count(f1) from t1 :
4 ---------------------------------------------------------
6 ---------------------------------------------------------
7 5
9 select sum(f1) from t1 :
10 ---------------------------------------------------------
12 ---------------------------------------------------------
13 500
15 select avg(f1) from t1 :
16 ---------------------------------------------------------
18 ---------------------------------------------------------
19 100
21 select min(f1) from t1 :
22 ---------------------------------------------------------
24 ---------------------------------------------------------
25 98
27 select max(f1) from t1 :
28 ---------------------------------------------------------
30 ---------------------------------------------------------
31 102