YouTube on MSN

SQL tricks with billionaires data

Intermediate SQL tutorial demonstrating REGEXP for advanced filtering, IF & CASE statements to create categories, SUBQUERIES for complex analysis, and JOINS for combining multiple tables — all shown ...
Simon Fraser University

Using a Pass-Through Query in a Subquery

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...