SQL: Difference between revisions

From wikinotes
Line 28: Line 28:
|-
|-
| [[sql: dates]]
| [[sql: dates]]
|-
| [[sql: optimization]]
|-
|-
|}
|}
Line 48: Line 50:
|-
|-
| [[sql: aggregate functions]]
| [[sql: aggregate functions]]
|-
| [[sql: optimization]]
|-
|-
|}
|}
</blockquote><!-- Notes -->
</blockquote><!-- Notes -->

Revision as of 18:18, 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: datatypes
sql: dates
sql: optimization

Mutations

sql: mutations

Queries

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