Learn SQL by example
The goal of this project is to show you the different SQL syntax in most popular RDBMSs and be as short as possible and refference to a reliable source for more info. You can set up your environment and import sample data in the Setup post. If you find any issues or want to add more examples, feel free to open an issue or send a pull request in GitHub.
Introduction
Database and Table Management
Modifying Data
Query and Filtering Data
- SELECT
- WHERE
- ORDER BY
- GROUP BY
- AND, OR, NOT
- LIMIT
- Comment
- MIN, MAX
- COUNT, SUM, AVG
- AS
- LIKE
- SELECT DISTINCT
- IN
- BETWEEN
