About this document

Advanced SQL Joins in Oracle by Nguyễn Tùng Anh is a document available to read on EtoBox.

This document discusses advanced SQL select statements using Oracle, including joins, subqueries, set operations, and correlated subqueries. It covers equi-joins, non-equi-joins, outer joins with both the old and new syntaxes, self-joins, and top-N analysis using rownum. Single-row and multiple-row subqueries are explained along with the EXISTS operator for correlated subqueries. Taking an incremental approach by building queries from the innermost subquery out is recommended for learning.

Author

Nguyễn Tùng Anh

Language

EN