Lines Matching refs:d

21   CREATE TABLE t1(a,b,c,d);
26 SELECT d FROM t1 WHERE a=? AND b=? AND c>=? ORDER BY c;
30 SELECT d FROM t1 WHERE a=? AND b=? AND c>=? ORDER BY c;
35 CREATE TABLE t1(a,b,c,d);
40 SELECT d FROM t1 WHERE a=? AND b=? AND c>=? ORDER BY c;
44 SELECT d FROM t1 WHERE a=? AND b=? AND c>=? ORDER BY c;
49 CREATE TABLE t1(a,b,c,d,e);
50 CREATE INDEX t1cd ON t1(c,d);
51 CREATE INDEX t1bcd ON t1(b,c,d);
52 CREATE INDEX t1abcd ON t1(a,b,c,d);
55 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
59 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
64 CREATE TABLE t1(a,b,c,d,e);
65 CREATE INDEX t1cd ON t1(c,d);
66 CREATE INDEX t1abcd ON t1(a,b,c,d);
67 CREATE INDEX t1bcd ON t1(b,c,d);
70 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
74 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
79 CREATE TABLE t1(a,b,c,d,e);
80 CREATE INDEX t1bcd ON t1(b,c,d);
81 CREATE INDEX t1cd ON t1(c,d);
82 CREATE INDEX t1abcd ON t1(a,b,c,d);
85 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
89 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
94 CREATE TABLE t1(a,b,c,d,e);
95 CREATE INDEX t1bcd ON t1(b,c,d);
96 CREATE INDEX t1abcd ON t1(a,b,c,d);
97 CREATE INDEX t1cd ON t1(c,d);
100 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
104 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
109 CREATE TABLE t1(a,b,c,d,e);
110 CREATE INDEX t1abcd ON t1(a,b,c,d);
111 CREATE INDEX t1bcd ON t1(b,c,d);
112 CREATE INDEX t1cd ON t1(c,d);
115 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
119 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
124 CREATE TABLE t1(a,b,c,d,e);
125 CREATE INDEX t1abcd ON t1(a,b,c,d);
126 CREATE INDEX t1cd ON t1(c,d);
127 CREATE INDEX t1bcd ON t1(b,c,d);
130 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;
134 SELECT d FROM t1 WHERE a=? AND b=? AND c=? AND d>=? ORDER BY d;