614
614
select max(t1.a3), min(t2.a2) from t1, t2 where t1.a2 = 2 and t1.a3 < 'MIN' and t2.a3 > 'CA';
615
615
id select_type table type possible_keys key key_len ref rows Extra
616
616
1 SIMPLE t2 range k1 k1 3 NULL 1 Using where; Using index
619
619
select min(a4 - 0.01) from t1;
620
620
id select_type table type possible_keys key key_len ref rows Extra