SQL: Difference between revisions
From wikinotes
(→Notes) |
(→Notes) |
||
(14 intermediate revisions by the same user not shown) | |||
Line 22: | Line 22: | ||
= Notes = | = Notes = | ||
<blockquote> | <blockquote> | ||
General | |||
{| | {| | ||
|- | |- | ||
| [[sql | | [[sql schemas]] | ||
|- | |- | ||
| [[sql | | [[sql datatypes]] | ||
|- | |- | ||
| [[sql | |} | ||
Mutations | |||
{| | |||
|- | |||
| [[sql mutations]] | |||
|- | |||
|} | |||
Queries | |||
{| | |||
|- | |- | ||
| [[sql | | [[sql queries]] | ||
|- | |- | ||
| [[sql | | [[sql joins]] | ||
|- | |- | ||
| [[sql | | [[sql comparison operators]] | ||
|- | |- | ||
| [[sql | | [[sql conditionals]] | ||
|- | |- | ||
| [[sql | | [[sql functions]] | ||
|- | |- | ||
| [[sql | | [[sql aggregate functions]] | ||
|- | |- | ||
|} | |} | ||
</blockquote><!-- Notes --> | </blockquote><!-- Notes --> |
Latest revision as of 20:06, 4 September 2022
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 Mutations
sql mutations Queries
sql queries sql joins sql comparison operators sql conditionals sql functions sql aggregate functions