Analytical SQL

How to select the top-N rows per group with SQL in Oracle Database

How to select the top-N rows per group with SQL in Oracle Database

Chris Saxon 17 minute read
How to convert rows to columns (PIVOT) and back again (UNPIVOT) with SQL in Oracle Database

How to convert rows to columns (PIVOT) and back again (UNPIVOT) with ...

Chris Saxon 18 minute read
How to Find and Delete Duplicate Rows with SQL

How to Find and Delete Duplicate Rows with SQL

Chris Saxon 12 minute read
Finding the Previous Row in a Different Group Using SQL

Finding the Previous Row in a Different Group Using SQL

Chris Saxon 8 minute read
Fetching a Row Plus N Rows Either Side in a Single SQL Statement

Fetching a Row Plus N Rows Either Side in a Single SQL Statement

Chris Saxon 7 minute read

Receive the latest blog updates

Resources for
Why Oracle
Learn
What's New
Contact Us