возвратить дополнительную колонку с алгоритмом подсчета данных
Stack Overflow на русском Asked on February 14, 2021
Еще раз доброго дня!
ДАНО:
ЗАДАЧА:
Необходимо добавить 5-ую колонку "chage" в которой будут фиксироваться изменения в колонке
team в текущей игре относительно ее предыдущего матча.
Прошу помочь
ВИЗУАЛЬНЫЙ РЕЗУЛЬТАТ:
One Answer
Решение найдено:
SELECT
id,
match_date,
team,
score,
LEAD (team,0) OVER() - LAG (team) OVER () AS change
FROM matches
WHERE EXTRACT('year'FROM match_date) = 2017
Answered by Слово on February 14, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Answers
- haakon.io on Why fry rice before boiling?
- Peter Machado on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Jon Church on Why fry rice before boiling?
- Joshua Engel on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?