PS Query & SQL

We will cover:

- Subqueries
- Unions
- Drilling URLs
- Composite Query
- Intermediate to Advanced Expressions that can help you get the most out of your Query. We will look at using expressions as fields, using regular expressions to identify patterns, count information, and replace data in queries, using ListAgg to consolidate data into columns rather than multiple rows (and how to remove duplicates from ListAgg) and cover using case statements, decode, etc.

https://www.heug.org/communities/community-home/librarydocuments/viewdocument?DocumentKey=4a2b4b26-29fe-41dc-b0b4-18b6fa855603