Skip to content

Instantly share code, notes, and snippets.

@sqlparser
Created December 12, 2023 08:02
Show Gist options
  • Save sqlparser/689e9d855c317cf853f2fa809a2ac06c to your computer and use it in GitHub Desktop.
Save sqlparser/689e9d855c317cf853f2fa809a2ac06c to your computer and use it in GitHub Desktop.
DB2 Sample SQL
```sql
SELECT PART, SUPPLIER, PRODNUM, PRODUCT
FROM (SELECT PART, PROD# AS PRODNUM, SUPPLIER
FROM PARTS
WHERE PROD# < 200) AS PARTX
LEFT OUTER JOIN PRODUCTS
ON PRODNUM = PROD#;
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment