{"id":130385,"date":"2022-04-13T17:59:56","date_gmt":"2022-04-13T21:59:56","guid":{"rendered":"https:\/\/brainstation.io\/?post_type=codex-reference&p=130385"},"modified":"2025-02-04T14:41:15","modified_gmt":"2025-02-04T19:41:15","slug":"clause","status":"publish","type":"codex-reference","link":"https:\/\/brainstation.io\/learn\/sql\/clause","title":{"rendered":"Clause"},"content":{"rendered":"\n
<\/path><\/path><\/path><\/g><\/path><\/path><\/path><\/g><\/svg>

SQL tutorial<\/p><\/div>

SQL Clause<\/h1>

Learn more about SQL, a standard language for interacting with databases and storing, manipulating, and retrieving data from databases.

Go hands-on with SQL in our free interactive SQL tutorial.<\/a><\/p><\/div>

<\/div><\/div><\/div><\/header>\n\n\n\n
\n
\n

While statements in SQL are commands that are executed by a SQL engine, SQL clauses are modifiers to statements that alter their behavior. <\/p>\n\n\n\n

We\u2019ve seen in the previous section how to use SQL statements and to retrieve and modify data in a SQL database. However, for most of our queries, we were limited to returning or altering all the data from a table or that was the result of a statement. SQL clauses are the next most fundamental part of the language.<\/p>\n\n\n\n

Most SQL clauses are optional, however there are some that are essentially mandatory in order to execute a statement with a desired result; for example, using a GROUP BY<\/code> clause with a SELECT<\/code> statement which uses aggregation functions not applied over a whole table or result set.<\/p>\n\n\n\n

Additionally, most SQL clauses are associated with particular SQL statement types, as we see above with the GROUP BY<\/code> clause. The SQL clauses we will cover in this section are those most frequently used, and so are mainly to alter the behavior of SQL queries using SELECT<\/code>.<\/p>\n<\/div>\n\n\n\n

<\/div>\n<\/div>\n\n\n\n

Previous<\/p><\/path><\/svg><\/span>SQL Delete<\/span><\/a><\/div>

Next<\/p>SQL Where<\/span><\/path><\/svg><\/span><\/a><\/div><\/div><\/div>\n\n\n\n

<\/path><\/path><\/path><\/g><\/path><\/path><\/path><\/g><\/svg>
\n
\n
\n

Learn SQL Today<\/h2><\/div>\n\n\n\n

Get hands-on experience writing code with interactive tutorials in our free online learning platform.<\/p>\n\n\n\n

<\/div>\n\n\n\n