How to select the top-N rows per group with SQL in Oracle Database
oracle.com
How to select the top-N rows per group with SQL in Oracle Database
Fetching the first N rows from a result set is easy with the fetch first clause.But what if you want the top-N rows in each group? For example, the three most recent orders for each customer?Oracle Database 23ai adds new syntax to do this. In this post we'll explore how the new syntax works and approaches that work in earlier releases.
Jan 27, 2021
Related Products
Oracle Database Tuning
SQL Server Query
Order by Query in Oracle
#Oracle Database Tutorial
Oracle SQL Tutorial 1 - Intro to Oracle Database
Oracle SQL Tutorial 1 - Intro to Oracle Database
YouTubeJul 27, 2015
Oracle SQL Tutorial | Oracle DBA | Oracle SQL for Beginners | Great Learning
Oracle SQL Tutorial | Oracle DBA | Oracle SQL for Beginners | Great Learning
YouTubeAug 28, 2021
Top videos
Oracle SQL Tutorial 9 - Intro to Queries
4:55
Oracle SQL Tutorial 9 - Intro to Queries
YouTubeCaleb Curry
89.2K viewsNov 25, 2016
Tutorial#17 How Oracle SQL Query Work Internally
8:03
Tutorial#17 How Oracle SQL Query Work Internally
YouTubeEqualConnect Coach
22.6K viewsAug 3, 2018
Advanced SQL Tutorial | Subqueries
8:37
Advanced SQL Tutorial | Subqueries
YouTubeAlex The Analyst
413.8K viewsApr 20, 2021
Oracle Cloud Services
Oracle shares skyrocket on AI cloud growth | REUTERS
1:46
Oracle shares skyrocket on AI cloud growth | REUTERS
YouTubeReuters
1.1K views3 days ago
Day One and Beyond: Oracle Cloud Security QuickStart
52:01
Day One and Beyond: Oracle Cloud Security QuickStart
YouTubeOracle Developers
82 views3 days ago
� OCI Deep Dive: Getting Started as a Cloud Architect � September 9, 2025 · 7 PM IST – Set Reminder � Step into the world of Oracle Cloud Infrastructure (OCI) with this focused deep dive for aspiring cloud architects. In this session, you’ll learn the essentials of OCI’s core services, from storage to databases, and understand how these building blocks form the foundation for enterprise-grade cloud solutions. � What you’ll learn: – Introduction to Oracle Cloud Infrastructure (OCI) – Key OCI stor
� OCI Deep Dive: Getting Started as a Cloud Architect � September 9, 2025 · 7 PM IST – Set Reminder � Step into the world of Oracle Cloud Infrastructure (OCI) with this focused deep dive for aspiring cloud architects. In this session, you’ll learn the essentials of OCI’s core services, from storage to databases, and understand how these building blocks form the foundation for enterprise-grade cloud solutions. � What you’ll learn: – Introduction to Oracle Cloud Infrastructure (OCI) – Key OCI stor
FacebookKoenig Solutions Pvt. Ltd.
24 views4 days ago
Oracle SQL Tutorial 9 - Intro to Queries
4:55
Oracle SQL Tutorial 9 - Intro to Queries
89.2K viewsNov 25, 2016
YouTubeCaleb Curry
Tutorial#17 How Oracle SQL Query Work Internally
8:03
Tutorial#17 How Oracle SQL Query Work Internally
22.6K viewsAug 3, 2018
YouTubeEqualConnect Coach
Advanced SQL Tutorial | Subqueries
8:37
Advanced SQL Tutorial | Subqueries
413.8K viewsApr 20, 2021
YouTubeAlex The Analyst
Subquery In SQL | SQL Subquery Tutorial With Examples | SQL Tutorial For Beginners | Simplilearn
22:47
Subquery In SQL | SQL Subquery Tutorial With Examples | SQL Tuto…
228.8K viewsApr 19, 2021
YouTubeSimplilearn
Reporting and Analytics - iQuery | Learn Oracle | Oracle Training and Certification
Reporting and Analytics - iQuery | Learn Oracle | Oracle Training an…
May 15, 2020
oracle.com
Oracle SQL Tutorial : Using execution plan to optimize query in oracle
12:54
Oracle SQL Tutorial : Using execution plan to optimize query i…
59.3K viewsMay 3, 2017
YouTubeTech Query Pond
SQL Tutorial in Oracle - 1
6:08
SQL Tutorial in Oracle - 1
233.8K viewsDec 12, 2015
YouTubeTelusko
1:40
How to Use a Loop with a Query in Oracle SQL
2 views5 months ago
YouTubevlogize
4:17
Learn Oracle SQL : Introduction to Hierarchical Queries
7.2K viewsNov 17, 2017
YouTubeOracle SQL
1:10:44
Subquery in SQL | Correlated Subquery + Complete SQL Subqu…
1.2M viewsFeb 1, 2022
YouTubetechTFQ
2:14
How to Use the EXISTS Operator for Effective SQL Queries in Oracle
1 views3 months ago
YouTubevlogize
11:19
Learn Oracle SQL : The Hierarchical Query Clause
38.9K viewsNov 17, 2017
YouTubeOracle SQL
8:32
Oracle SQLcl Introduction and Getting Started
90K viewsSep 9, 2016
YouTubeJeff Smith
3:05
Hierarchical Queries in Oracle (CONNECT BY)
45.3K viewsJul 16, 2015
YouTubeORACLE-BASE.com
6:43
5 Basic SELECT Statement Queries in SQL
154.8K viewsJan 4, 2020
YouTubeBecoming a Data Scientist
3:28:29
Oracle SQL Tutorial | Oracle DBA | Oracle SQL for Beginners | Great …
1.2M viewsAug 28, 2021
YouTubeGreat Learning
1:13:14
Oracle SQL Developer - Full Course
335.5K viewsAug 23, 2018
YouTubeDatabases A2Z
22:40
PL/SQL Oracle tutorial, Oracle introduction, PL/SQL basics (Less…
271.3K viewsApr 4, 2012
YouTubeLearn with video tutorials
9:39
Oracle SQL Developer Tutorial (Feature Demonstration)
99.3K viewsJun 3, 2021
YouTubeDatabase Star
18:22
SQL Tutorial for Beginners | Oracle Live SQL | SQL Worksheet 1
104.1K viewsFeb 10, 2018
YouTubeDave Developed
2:06
Oracle - SQL - Getting Started
183.8K viewsFeb 2, 2018
YouTubeTutorialsPoint
8:54
How to find Hierarchies in Oracle (CONNECT BY) & Self Join|Hierarc…
14.5K viewsFeb 22, 2020
YouTubeNIC IT ACADEMY
3:34
How to execute DBMS queries in oracle 10g
22.2K viewsDec 7, 2014
YouTubeMAkeEAsy
Select Query – Oracle PL/SQL Tutorial
Jan 3, 2015
plsql.co
1:30
Create Your First Analysis in Oracle Analytics
50K viewsOct 25, 2021
YouTubeOracle Learning
14:33
Introduction to Oracle Database | What is Oracle? full Explanation
655K viewsJul 13, 2021
YouTubeLearn Coding
1:54
How to Get the Latest Value from a Group By Query in Oracle SQL
5 months ago
YouTubevlogize
5:57
Secret To Optimizing SQL Queries - Understand The SQL Execution Or…
572.2K viewsMay 16, 2023
YouTubeByteByteGo
1:29
How to Order a SQL Query with Null Values First in Oracle
3 months ago
YouTubevlogize
See more videos
Static thumbnail place holder