Lines Matching refs:y

54     SELECT x, sequence() AS y FROM t1 WHERE y>0
60     SELECT x, sequence() AS y FROM t1 WHERE y>0 AND y<99
66     SELECT x, sequence() AS y FROM t1 WHERE y>0 AND y<99 AND y!=55
72     SELECT x, sequence() AS y FROM t1
73      WHERE y>0 AND y<99 AND y!=55 AND y NOT IN (56,57,58)
74        AND y NOT LIKE 'abc%' AND y%10==2
80     SELECT x, sequence() AS y FROM t1 WHERE y BETWEEN 0 AND 99
86 #    SELECT x, sequence() AS y FROM t1 WHERE y IN (55,66,3)
92     SELECT x, 1-sequence() AS y FROM t1 ORDER BY y
98     SELECT x, sequence() AS y FROM t1 ORDER BY -y
104     SELECT x, sequence() AS y FROM t1 ORDER BY x%2, y
135       SELECT sequence(*) AS y, count(*) AS z FROM t1 GROUP BY y ORDER BY z, y