1 echo select min(t1.notexist) from t1;
2 select min(t1.notexist) from t1;
4 echo select max(t1.f1), sum(t2.f1) from t1,t2 where t1.f1 = t2.f1 and t1.f1 <100;
5 select max(t1.f1), sum(t2.f1) from t1,t2 where t1.f1 = t2.f1 and t1.f1 <100;
7 echo select max(t1.f1), sum(t2.f1) from t1,t2 where t1.f1 = t2.f1 and t1.f1 <100 group by t1.f2;
8 select max(t1.f1), sum(t2.f1) from t1,t2 where t1.f1 = t2.f1 and t1.f1 <100 group by t1.f2;
10 echo select max(t1.f1), max(t2.notexist) from t1,t2 group by t1.f2;
11 select max(t1.f1), max(t2.notexist) from t1,t2 group by t1.f2;