{"slug":"saylorinnovations-com-api-kb-sql-window-functions-cookbook-r-627357","title":"SQL window functions cookbook","host":"saylorinnovations.com","method":"GET","resource":"https://saylorinnovations.com/api/kb/sql-window-functions-cookbook-running-totals-top-n","category":"other","description":"SQL window functions cookbook - running totals, top-N per group, rank vs row_number, LAG, moving average, frame traps","price_listed":0.01,"price_asked":0.01,"state":"answering","state_label":"Answering","checks_7d":1,"answered_7d":1,"latency_ms_median":295,"reported_calls_30d":0,"reported_payers_30d":0,"networks":["eip155:137","eip155:42161","eip155:8453","solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"method":"GET","type":"http"},"output_schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"method":{"enum":["GET"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method"],"type":"object"},"output":{"properties":{"example":{"properties":{"body":{"description":"Main body text","type":"string"},"c":{"description":"Category of the guide","type":"string"},"id":{"description":"Identifier of the record","type":"string"},"license":{"description":"License identifier","type":"string"},"price":{"description":"Price","type":["number","null"]},"t":{"description":"Title of the guide","type":"string"}},"required":["id","t","c","body"],"type":"object"},"type":{"const":"json","type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"},"history":[{"day":"2026-10-20","reachable":true,"status":402,"valid_402":true,"asked_usdc":0.01,"price_match":true,"latency_ms":295,"error":null}],"description_full":"SQL window functions cookbook - running totals, top-N per group, rank vs row_number, LAG, moving average, frame traps","last_updated":"2026-10-20T12:55:35.417Z","schemes":["exact"]}