Lines Matching refs:A
35 CREATE TABLE T2 (A INTEGER NOT NULL,
38 PRIMARY KEY (A, B, C));
40 INSERT INTO T2(A, B, C) VALUES(702118,16183,15527);
41 INSERT INTO T2(A, B, C) VALUES(702118,16183,15560);
42 INSERT INTO T2(A, B, C) VALUES(702118,16183,15561);
43 INSERT INTO T2(A, B, C) VALUES(702118,16183,15563);
44 INSERT INTO T2(A, B, C) VALUES(702118,16183,15564);
45 INSERT INTO T2(A, B, C) VALUES(702118,16183,15566);
46 INSERT INTO T2(A, B, C) VALUES(702118,16183,15567);
47 INSERT INTO T2(A, B, C) VALUES(702118,16183,15569);
48 INSERT INTO T2(A, B, C) VALUES(702118,16183,15612);
49 INSERT INTO T2(A, B, C) VALUES(702118,16183,15613);
50 INSERT INTO T2(A, B, C) VALUES(702118,16183,15638);
51 INSERT INTO T2(A, B, C) VALUES(702118,16183,15681);
52 INSERT INTO T2(A, B, C) VALUES(702118,16183,15682);
71 SELECT T2.A, T2.B, T1.D, T1.E, T1.F, T1.G, T1.H, MAX(T1.C), '^'
75 GROUP BY T2.A, T2.B, T1.D, T1.E, T1.F, T1.G, T1.H
81 SELECT T2.A, T2.B, T1.D, T1.E, T1.F, T1.G, T1.H, MAX(T1.C), '^'
85 GROUP BY T2.A, T2.B, T1.F, T1.D, T1.E, T1.G, T1.H