Chapter 4. Advanced SQL Coding
Subqueries
Unions
Joins
Nested Table Expressions
CASE Expressions
Row Expressions
OLAP and Star Joins
This chapter covers some of the more advanced features found in DB2's SQL. We start with discussions on the constructs of subqueries, unions, and joins. Then we examine nested table expressions, the CASE expression with its if–then–else logic, row expressions, and OLAP features.
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.