---
title: "Discussion on \"Streaming SQL Window Functions: Tumbling, Hopping, Session, and Cumulative\" | Hashnode"
description: "Discussion on \"Streaming SQL Window Functions: Tumbling, Hopping, Session, and Cumulative\". A practical guide to the four window function patterns in RisingWave, with working SQL examples for each and the real use case behind them."
url: "https://hashnode.com/posts/streaming-sql-window-functions-tumbling-hopping-session/6a10c6b5ba30e458567fef58"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Streaming SQL Window Functions: Tumbling, Hopping, Session, and Cumulative](https://risingwave.com/blog/streaming-sql-window-functions-tumbling-hopping-session?utm_source=hashnode&utm_medium=feed)

A practical guide to the four window function patterns in RisingWave, with working SQL examples for each and the real use case behind them.

May 22 · 8 min read · risingwave.com  
Read the article

-   [#streaming-sql](https://hashnode.com/tag/streaming-sql)
-   [#window-functions](https://hashnode.com/tag/window-functions)
-   [#tumble](https://hashnode.com/tag/tumble)
-   [#hop](https://hashnode.com/tag/hop)
-   [#session](https://hashnode.com/tag/session)
-   [#risingwave](https://hashnode.com/tag/risingwave)

## Written by

[RisingWave Labs](https://hashnode.com/@RisingWaveLabs)

@RisingWaveLabs · Bay Area, California

  
[View profile](https://hashnode.com/@RisingWaveLabs)

RisingWave is an open-source real-time event streaming platform.

RisingWave is a real-time event streaming platform designed to offer the simplest and most cost-effective way to process, analyze, and manage real-time event data — with built-in support for the Apache Iceberg™ open table format. It provides both a Postgres-compatible SQL interface and a DataFrame-style Python interface. RisingWave can ingest millions of events per second, continuously join and analyze live streams with historical data, serve ad-hoc queries at low latency, and manage data reliably in Apache Iceberg™ tables.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.