Lines Matching refs:total

413   CREATE TABLE sales(emp TEXT PRIMARY KEY, region, total);
428   SELECT emp, region, total FROM (
430       emp, region, total,
431       row_number() OVER (PARTITION BY region ORDER BY total DESC) AS rank
433   ) WHERE rank<=2 ORDER BY region, total DESC
443   SELECT emp, region, sum(total) OVER win FROM sales
444   WINDOW win AS (PARTITION BY region ORDER BY total)
457   SELECT emp, region, sum(total) OVER win FROM sales
458   WINDOW win AS (PARTITION BY region ORDER BY total)
469   SELECT emp, region, sum(total) OVER win FROM sales
470   WINDOW win AS (PARTITION BY region ORDER BY total)
481   SELECT emp, region, sum(total) OVER win FROM sales
483     PARTITION BY region ORDER BY total 
498   SELECT emp, region, sum(total) OVER win FROM sales
500     PARTITION BY region ORDER BY total 
513     SELECT sum(total) OVER (
514       ORDER BY total RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
530     SELECT sum(total) FILTER (WHERE sales.emp!=outer.emp) OVER (
531       ORDER BY total RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
1302           SELECT total(d) OVER (ORDER BY c)
1949          + total(a) OVER() 
1956          + total(a) OVER() 
2105     SELECT total(a) OVER ( $spec ) FROM t1 ORDER BY a
2127     SELECT total(a) OVER ( $spec ) FROM t2 ORDER BY a