Lines Matching refs:seq
54 CREATE TABLE t1(seq INTEGER PRIMARY KEY, val TEXT);
70 WHERE a.seq<b.seq
76 WHERE a.seq<>b.seq
82 WHERE a.seq>b.seq
86 SELECT seq FROM t1 ORDER BY val COLLATE decimal;
89 SELECT seq FROM t1 ORDER BY val COLLATE decimal DESC;
93 CREATE TABLE t3(seq INTEGER PRIMARY KEY, val TEXT);
95 INSERT INTO t3(seq, val) SELECT x, x FROM c;
97 INSERT INTO t3(seq, val) SELECT x+10, x*1000 FROM c;
98 SELECT decimal(val) FROM t3 ORDER BY seq;
101 SELECT decimal_add(val,'0.5') FROM t3 WHERE seq>5 ORDER BY seq
104 SELECT decimal_add(val,'-10') FROM t3 ORDER BY seq;