This is also a good reference for DB2 SQL that I keep bookmarked.

https://aurora.vcu.edu/db2help/db2s0/frame3.htm