# SQL Clauses

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: SQL Clauses
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-clauses/index
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-clauses/index.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-clauses/index.adoc
description: SQL clauses define how data is retrieved, filtered, and manipulated.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-clauses.md -->

SQL clauses define how data is retrieved, filtered, and manipulated. They specify what data to include, how to organize it, and the conditions rows must meet to appear in the result set.

Redpanda SQL supports the following clauses:

| Clause | Description |
| --- | --- |
| FROM | Defines the source tables or views for the query. |
| WHERE | Filters rows based on specified conditions. |
| GROUP BY | Groups rows sharing common values in specified columns for aggregation. |
| HAVING | Filters grouped rows based on aggregate conditions. |
| ORDER BY | Sorts the result set by specified columns in ascending or descending order. |
| LIMIT | Restricts the number of rows returned by the query. |
| OFFSET | Skips a specified number of rows before returning results. |
| SET OPERATIONS | Combines or compares results from multiple SELECT statements, such as UNION, INTERSECT, and EXCEPT. |
| WITH | Creates temporary named result sets (Common Table Expressions) for reuse within queries. |
| OVER | Specifies the window over which window functions operate on subsets of data. |