> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Queries (SQL)

Queries retrieve and combine data from *Kinetica* tables with the **SELECT**
statement. The features and functions below cover joins, aggregation, grouping
and windowing, set operations, common table expressions, subqueries, and the
full library of scalar and aggregate functions available in query expressions.

<CardGroup cols={2}>
  <Card title="Query Features">
    * [SELECT Statement](/content/sql/query/select-statement)
    * [Tableless Query](/content/sql/query/tableless-query)
    * [Join](/content/sql/query/join)
    * [Aggregation](/content/sql/query/aggregation)
    * [Grouping](/content/sql/query/grouping)
    * [Window](/content/sql/query/window)
    * [PIVOT](/content/sql/query/pivot)
    * [UNPIVOT](/content/sql/query/unpivot)
    * [Set Operations](/content/sql/query/set-operations)
    * [WITH (Common Table Expressions)](/content/sql/query/with-common-table-expressions)
    * [Iteration](/content/sql/query/iteration)
    * [Constants](/content/sql/query/constants)
    * [Expressions](/content/sql/query/expressions)
    * [Predicates](/content/sql/query/predicates)
    * [Subqueries](/content/sql/query/subqueries)
    * [Remote Queries](/content/sql/query/remote-queries)
    * [Hints](/content/sql/query/hints)
    * [EXPLAIN](/content/sql/query/explain)
  </Card>

  <Card title="Functions">
    * [Array Functions](/content/sql/query/array-functions)
    * [Conditional Functions](/content/sql/query/conditional-functions)
    * [Conversion Functions](/content/sql/query/conversion-functions)
    * [Date/Time Functions](/content/sql/query/date-time-functions)
    * [Geospatial/Geometry Functions](/content/sql/query/geospatial-geometry-functions)
    * [JSON Functions](/content/sql/query/json-functions)
    * [Math Functions](/content/sql/query/math-functions)
    * [Null Functions](/content/sql/query/null-functions)
    * [String Functions](/content/sql/query/string-functions)
    * [User/Security Functions](/content/sql/query/user-security-functions)
    * [Aggregation Functions](/content/sql/query/aggregation-functions)
    * [Grouping Functions](/content/sql/query/grouping-functions)
    * [ML Functions](/content/sql/query/ml-functions)
    * [Distribution Functions](/content/sql/query/distribution-functions)
  </Card>
</CardGroup>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.