3 #3. 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
22 echo "select count(*),min(f1),sum(f1) from t1 :"
23 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/agg1.sql
26 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1
32 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1.sql
> /dev
/null
2>&1