Skip to content

Instantly share code, notes, and snippets.

@sqlparser

sqlparser/gist:689e9d855c317cf853f2fa809a2ac06c

Created December 12, 2023 08:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sqlparser/689e9d855c317cf853f2fa809a2ac06c to your computer and use it in GitHub Desktop.
Save sqlparser/689e9d855c317cf853f2fa809a2ac06c to your computer and use it in GitHub Desktop.
Download ZIP
DB2 Sample SQL
Raw
gistfile1.txt
```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