Lines Matching refs:e
28 CREATE TABLE t2(d, e, UNIQUE(d,e));
36 SELECT e FROM t1, t2 WHERE a=1 AND d=b ORDER BY d, e;
42 SELECT e FROM t1, t2 WHERE a=1 AND d=b ORDER BY d, e;
48 SELECT e FROM t1, t2 WHERE a=1 AND d=b ORDER BY e;
54 SELECT e FROM t1, t2 WHERE a=1 AND d=b ORDER BY e;
60 SELECT e, b FROM t1, t2 WHERE a=1 ORDER BY d, e;
66 SELECT e, b FROM t1, t2 WHERE a=1 ORDER BY d, e;
76 CREATE TABLE t33(e,f); CREATE INDEX t33ef ON t33(e,f);
84 SELECT a||','||c||','||e||','||g FROM t31, t32, t33, t34
85 WHERE c=b AND e=d AND g=f
86 ORDER BY a ASC, c ASC, e DESC, g ASC;
91 SELECT a||','||c||','||e||','||g FROM t31, t32, t33, t34
92 WHERE c=b AND e=d AND g=f
93 ORDER BY +a ASC, +c ASC, +e DESC, +g ASC;
98 SELECT a||','||c||','||e||','||g FROM t31, t32, t33, t34
99 WHERE c=b AND e=d AND g=f
100 ORDER BY a ASC, c ASC, e ASC, g ASC;
107 SELECT a||','||c||','||e||','||g FROM t31, t32, t33, t34
108 WHERE c=b AND e=d AND g=f
109 ORDER BY a ASC, c ASC, e ASC, g ASC;