# SELECT
<a name="sql-commands-select-spark"></a>

The SELECT command returns rows from tables and user-defined functions.

The following SELECT SQL commands, clauses, and set operators are supported in AWS Clean Rooms Spark SQL:

**Topics**
+ [SELECT list](sql-function-select-list-spark.md)
+ [WITH clause](WITH_clause.md)
+ [FROM clause](FROM_clause30.md)
+ [JOIN clause](join-clause.md)
+ [WHERE clause](WHERE_clause.md)
+ [VALUES clause](VALUES.md)
+ [GROUP BY clause](GROUP_BY_clause.md)
+ [HAVING clause](HAVING_clause.md)
+ [Set operators](UNION.md)
+ [ORDER BY clause](ORDER_BY_clause.md)
+ [Subquery examples](Subquery_examples.md)
+ [Correlated subqueries](correlated_subqueries.md)

The syntax, arguments, and some examples come from the [Apache Spark SQL Reference](https://spark.apache.org/docs/latest/api/sql/).