Дана таблица:
A | B | C |
---|---|---|
4 | 5 | 1 |
5 | 2 | 6 |
1 | 9 | 4 |
2 | 12 | 20 |
8 | 10 | 4 |
12 | 0 | 9 |
(Отметьте один правильный вариант ответа.)
Варианты ответа
SELECT a, b, c, b - LAG(b,1) OVER (ORDER BY b) AS "Analytic function"FROM vtable;
SELECT a, b, c, RATIO_TO_REPORT (b) OVER () AS "Analytic function"FROM vtable;
SELECT a, b, c, ROW_NUMBER () OVER (ORDER BY a) AS "Analytic function"FROM vtable;(Верный ответ)
SELECT a, b, c, SUM(c) OVER (ORDER BY с RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT_ROW) AS "Analytic function"FROM vtable;