выпускать: 2026/04/30 01:01 читать: 0
Оригинальный автор:SashaOnChain
Первоисточник:https://www.youtube.com/embed/wQUVaaEfNDc
Ranking Window Functions in SQL | Crypto SQL Advanced #2 In this video, we break down one of the most important concepts in SQL for on-chain analytics — window functions. Instead of learning theory, we solve a real problem step by step: how to get the latest price for multiple tokens You’ll see: - why GROUP BY doesn’t work in this case - how window functions solve the problem - how row_number() works in practice - the difference between row_number, rank, and dense_rank This is part of my Crypto SQL Advanced series, where we move beyond syntax and start thinking like analysts. 00:00 Intro — Latest price problem 00:20 Adding more tokens (USDC & USDT) 00:33 Why GROUP BY fails 00:54 What we actually need 01:29 Window Functions explained 01:42 ROW_NUMBER + partitioning idea 02:11 Solving: latest price per token 02:36 RANK vs DENSE_RANK vs ROW_NUMBER 03:03 Outro — next steps #onchainanalytics #duneanalytics #crypto
WyWayt
2026-04-30 11:05
Lý Tiểu Han
2026-04-30 11:05
SashaOnChain
2026-04-30 11:05
Posit PBC
2026-04-30 11:05
超V社区🚩币圈聚合群KOL克隆群🚩比特币陈哥TraderChenge比特币峰哥比特币飞扬
2026-04-30 10:35
gham
2026-04-30 09:56
forex by mukul
2026-04-30 09:56
蒼沐追劇社
2026-04-30 09:17
love and peace forever
2026-04-30 09:16
Выберите валюту
US Dollar
USD
Chinese Yuan
CNY
Japanese Yen
JPY
South Korean Won
KRW
New Taiwan Dollar
TWD
Canadian Dollar
CAD
Euro
EUR
Pound Sterling
GBP
Danish Krone
DKK
Hong Kong Dollar
HKD
Australian Dollar
AUD
Brazilian Real
BRL
Swiss Franc
CHF
Chilean Peso
CLP
Czech Koruna KČ
CZK
Singapore Dollar
SGD
Indian Rupee
INR
Saudi Riyal
SAR
Vietnamese Dong
VND
Thai Baht
THB
Выберите валюту
US Dollar
USD-$
Chinese Yuan
CNY-¥
Japanese Yen
JPY-¥
South Korean Won
KRW -₩
New Taiwan Dollar
TWD-NT$
Canadian Dollar
CAD-$
Euro
EUR - €
Pound Sterling
GBP-£
Danish Krone
DKK-KR
Hong Kong Dollar
HKD- $
Australian Dollar
AUD-$
Brazilian Real
BRL -R$
Swiss Franc
CHF -FR
Chilean Peso
CLP-$
Czech Koruna KČ
CZK -KČ
Singapore Dollar
SGD-S$
Indian Rupee
INR -₹
Saudi Riyal
SAR -SAR
Vietnamese Dong
VND-₫
Thai Baht
THB -฿