Lines Matching refs:w1

386       SELECT a, max(d) OVER w1 FROM t1
387         WINDOW w1 AS (PARTITION BY EXISTS(SELECT 1 FROM t1 WHERE c=?1) );
394         SELECT a, max(d) OVER w1 FROM t1
395         WINDOW w1 AS (
403         SELECT a, max(d) OVER w1 FROM t1
404         WINDOW w1 AS (
731   SELECT rowid, sum(a) OVER w1 FROM t7 
732   WINDOW w1 AS (PARTITION BY b IN (SELECT rowid FROM t7));
1130   SELECT group_concat(b,'') OVER w1 FROM t1
1131     WINDOW w1 AS (ORDER BY a RANGE BETWEEN 3 PRECEDING AND 1 PRECEDING)
1152   SELECT a, b, c, quote(d), group_concat(b,'') OVER w1, '|' FROM t1
1153     WINDOW w1 AS
1185   SELECT a, b, c, quote(d), group_concat(b,'') OVER w1, '|' FROM t1
1186     WINDOW w1 AS
2141       SELECT nth_value(a,2) OVER w1 
2142       WINDOW w1 AS ( ORDER BY ((SELECT 1 FROM v1)) )
2148       SELECT nth_value(a,2) OVER w1 
2149       WINDOW w1 AS ( ORDER BY ((SELECT 1 FROM t2)) )