Zeitpunkt Nutzer Delta Tröts TNR Titel Version maxTL Mo 29.07.2024 00:00:12 61.965 -1 3.587.302 57,9 Fosstodon 4.2.10 500 So 28.07.2024 00:00:15 61.966 +3 3.586.611 57,9 Fosstodon 4.2.10 500 Sa 27.07.2024 00:00:14 61.963 +5 3.583.830 57,8 Fosstodon 4.2.10 500 Fr 26.07.2024 00:01:07 61.958 +1 3.580.868 57,8 Fosstodon 4.2.10 500 Do 25.07.2024 00:00:10 61.957 +1 3.577.506 57,7 Fosstodon 4.2.10 500 Mi 24.07.2024 00:01:07 61.956 0 3.574.077 57,7 Fosstodon 4.2.10 500 Di 23.07.2024 00:00:03 61.956 -3 3.570.705 57,6 Fosstodon 4.2.10 500 Mo 22.07.2024 00:01:10 61.959 +1 3.567.825 57,6 Fosstodon 4.2.10 500 So 21.07.2024 00:01:07 61.958 +1 3.564.861 57,5 Fosstodon 4.2.10 500 Sa 20.07.2024 00:01:10 61.957 0 3.561.604 57,5 Fosstodon 4.2.10 500
Tomasz Nurkiewicz πΊπ¦ (@nurkiewicz) · 11/2022 · Tröts: 662 · Folger: 874
Mo 29.07.2024 13:30
Great explanation of recursive CTE in #SQL: "Recursion in SQL Explained Visually": https://medium.com/swlh/recursion-in-sql-explained-graphically-679f6a0f143b. Biggest insight: recursion in SQL is actually an iterative process that applies the same function over and over again on the results of the previous invocation of said function. It's more like `reduce` or `foldLeft` (which is sort of recursive)
[Öffentlich] Antw.: 0 Wtrl.: 1 Fav.: 0 · via Elk