3 #5. Create table t1 with 5 records in csql database.
4 # select query with count,sum,avg,min,max.and Group By.
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/createt1t2.sql
> /dev
/null
2>&1
21 echo "select max(t1.f1), sum(t2.f1) from t1, t2 where t1.f1 = t2.f1 and t1.f1 <100 group by t1.f1 :"
22 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/groupby1.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
29 echo "select max(t1.f1), sum(t2.f1) from t1, t2 where t1.f1 = t2.f1 and t1.f1 <100 group by t1.f1, t2.f1 :"
30 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/groupby2.sql
33 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
39 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1