3 #1. Create table t1 with 5 records in csql database.
4 # select query with count,sum,avg,min,max.
6 # Author : Jitendra Lenka
8 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
12 REL_PATH
=`pwd`/sql
/Aggregate
15 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1.sql
> /dev
/null
2>&1
21 echo "select count(f1) from nonExistTab :"
22 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/aggcount1.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1
29 echo "select count(f1) from t1 :"
30 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/aggcount2.sql
33 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1
37 echo "select sum(f1) from t1 :"
38 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/aggsum1.sql
41 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1
45 echo "select avg(f1) from t1 :"
46 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/aggavg1.sql
49 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1
53 echo "select min(f1) from t1 :"
54 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/aggmin1.sql
57 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1
61 echo "select max(f1) from t1 :"
62 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/aggmax1.sql
65 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1
69 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1