2 # create table t1(f1 int,f2 int,f3 int,primary key(f1));
3 # create table t2(f1 int,f2 int,f3 int,primary key(f1));
4 # Insert 5 records in each.
5 # select query with count,sum,avg,min,max.and Group By.
7 # Author : Jitendra Lenka
9 QUITFILE
=${PWD}/sql
/Aggregate
/quit.sql
13 REL_PATH
=`pwd`/sql
/Aggregate
16 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/createt1t2.sql
> /dev
/null
2>&1
22 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/aggregate5.sql
25 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1
29 $CSQL_INSTALL_ROOT/bin
/csql
-s $REL_PATH/dropt1t2.sql
> /dev
/null
2>&1