Changes in new versions / SQL-92
Explicit JOIN instead of a comma
Outer joins
CASE expression
Type conversion with CAST
Date, time and INTERVAL types
EXCEPT and INTERSECT operators
Derived table in the FROM clause
EXCEPT and INTERSECT operators
This example is in the full version, available in the app stores:
SQL Recipes
App Store
Code Recipes
App Store
Already bought it? Sign in to your account