SQL: Difference between revisions

From wikinotes
Line 51: Line 51:
| [[sql functions]]
| [[sql functions]]
|-
|-
| [[sql: aggregate functions]]
| [[sql aggregate functions]]
|-
|-
|}
|}
</blockquote><!-- Notes -->
</blockquote><!-- Notes -->

Revision as of 18:35, 19 September 2021

The SQL spec is standardized by ISO/ANSI and must be purchased.
It's difficult to validate these notes without it.
This attempts to document the more general SQL-ish features available across SQL databases.

Documentation

SQL spec (unofficial) https://jakewheat.github.io/sql-overview/

Challenges

https://quip.com/2gwZArKuWk7W

Notes

General

sql schemas
sql: datatypes
sql: optimization

Mutations

sql: mutations

Queries

sql: queries
sql: joins
sql: comparison operators
sql functions
sql aggregate functions