SQL (source code)
= SQL
{c}
{wiki}
<SQL> is a language family for defining and querying <relational databases> and modifying their contents. A query such as `SELECT customer, COUNT(*) FROM orders GROUP BY customer` groups rows by customer and counts each group. A `WHERE` condition filters rows before grouping; `HAVING` filters groups afterward. Implementations usually use bag semantics, retaining duplicates unless removed explicitly. Null values also introduce three-valued condition evaluation, so ordinary two-valued logical rewrites need care. Standard features and vendor extensions must be distinguished when portability matters.https://www.postgresql.org/docs/current/queries-table-expressions.html[PostgreSQL documentation, §7.2, table-expression pipeline]{ref}
Back to article page