EN
SQL - fundamentals (Cross technology)
0
points
Below is a list of basic SQL concepts with references to various database management systems.
| Problem | Cross | MySQL | MS SQL Server | PostgreSQL | SQLite |
|---|---|---|---|---|---|
| Aliases | - | - | - | link | - |
| Alter Table | link | link | link | link | - |
| AND, OR, NOT operators | link | link | link | link | - |
| BETWEEN clause | link | link | link | link | - |
| CASE statement | link | link | link | link | - |
| Comments | link | link | link | link | - |
| Create database | link | link | link | link | - |
| Create table | link | link | link | link | - |
| Create view | link | link | link | link | - |
| Delete query | link | link | link | link | - |
| Drop database | link | link | link | link | - |
| Drop table | link | link | - | link | - |
| Drop view | link | link | - | link | - |
| Full Outer Join | link | link | link | link | - |
| GROUP BY statement | link | link | link | link | - |
| Inner Join | link | link | link | - | - |
| INSERT INTO statement | link | link | link | link | - |
| JOIN list + SQL Query | link | link | link | link | - |
| Left Join | link | link | link | - | - |
| LIKE operator | link | link | link | link | - |
| LIMIT clause | link | link | link | link | - |
| ORDER BY clause | link | link | link | link | - |
| Right Join | link | link | link | - | - |
| SELECT DISTINCT statement | link | link | link | link | - |
| Select query | link | link | link | - | - |
| UPDATE statement | link | link | link | link | - |
| WHERE clause | link | link | link | link | - |