Differences between Subqueries and CTEs (WITH clauses)

For those new to data analysis, I will explain the differences and proper usage of the two tools for organizing complex ...
YouTube on MSN

SQL tricks with billionaires data

Intermediate SQL tutorial demonstrating REGEXP for advanced filtering, IF & CASE statements to create categories, SUBQUERIES ...
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 ...
YouTube on MSN

How to solve advanced SQL problems step by step

Hard SQL interview questions test the advanced problem solving skills expected in many medium and senior level data analyst roles. The first challenge uses ROW NUMBER with PARTITION BY, a subquery, ...
techtarget

T-SQL (Transact-SQL)

T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including ...