PS Query & SQL

 View Only

Query For Functional Users - Intermediate to Advanced Functionality 

01-18-2025 12:43 PM

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


#PSQuery
#Functional
#Intermediate
#Advanced

Attachment(s)
pdf file
Alliance 2019 PS Query for Functional Users - Intermediat....pdf   8.75 MB   1 version
Uploaded - 01-18-2025
pptx file
Alliance 2019 PS Query for Functional Users - Intermediat....pptx   17.20 MB   1 version
Uploaded - 01-18-2025

Related Entries and Links

No Related Resource entered.