Lines Matching refs:xyz

21   CREATE TABLE xyz(one, two, thr, fou);
22   INSERT INTO xyz VALUES('A', 'A', 'A',  1);
23   INSERT INTO xyz VALUES('B', 'B', 'B',  2);
24   INSERT INTO xyz VALUES('C', 'C', 'C',  3);
25   INSERT INTO xyz VALUES('D', 'D', 'D',  4);
27   CREATE UNIQUE INDEX xyz_one_two ON xyz(one, two);
31   execsql { SELECT fou FROM xyz WHERE (one, two, thr) = ('B', 'B', 'B') }
37   execsql { SELECT fou FROM xyz WHERE (two, thr) IS ('C', 'C') }
43   execsql { SELECT fou FROM xyz WHERE (one, two, thr) > ('B', 'B', 'B') }
49   execsql { SELECT fou FROM xyz WHERE (one, two) IN (SELECT one, two FROM xyz) }
56     SELECT fou FROM xyz 
57     WHERE (one, two, thr) IN (SELECT one, two, thr FROM xyz) 
65     SELECT fou FROM xyz 
73     SELECT fou FROM xyz 
82     SELECT fou FROM xyz