SQL: Difference between revisions
From wikinotes
No edit summary |
(→Notes) |
||
(17 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{ | The SQL spec is standardized by ISO/ANSI and must be purchased.<br> | ||
It's difficult to validate these notes without it.<br> | |||
This attempts to document the more general SQL-ish features available across SQL databases. | |||
= Documentation = | |||
<blockquote> | |||
{| class="wikitable" | |||
|- | |||
| SQL spec (unofficial) || https://jakewheat.github.io/sql-overview/ | |||
|- | |||
|} | |||
</blockquote><!-- Documentation --> | |||
= Challenges = | = Challenges = | ||
Line 12: | Line 22: | ||
= Notes = | = Notes = | ||
<blockquote> | <blockquote> | ||
General | |||
{| | {| | ||
|- | |- | ||
| [[sql | | [[sql schemas]] | ||
|- | |||
| [[sql datatypes]] | |||
|- | |||
|} | |||
Mutations | |||
{| | |||
|- | |- | ||
| [[sql | | [[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