Accessibility Policy
Skip to content
Oracle
All Things SQL
Search
Exit Search Field
Clear Search Field
Menu
CATEGORIES
Analytical SQL
Big Data SQL
Data Warehousing
Partitioning
PL SQL
Query Optimization
RELATED CONTENT
The Magic of SQL
Simply Smarter SQL
Ask TOM
Oracle Dev Gym
Blogs Home
Featured Authors
RSS
All Things SQL
Follow:
RSS
Facebook
Twitter
LinkedIn
YouTube
Instagram
Analytical SQL
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 ...
Chris Saxon
18 minute read
How to Find and Delete Duplicate Rows with SQL
Chris Saxon
12 minute read
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
Chris Saxon
7 minute read
Receive the latest blog updates
Subscribe to receive the latest blog updates
Resources for
About
Careers
Developers
Investors
Partners
Startups
Why Oracle
Analyst Reports
Best CRM
Cloud Economics
Corporate Responsibility
Diversity and Inclusion
Security Practices
Learn
What is Customer Service?
What is ERP?
What is Marketing Automation?
What is Procurement?
What is Talent Management?
What is VM?
What's New
Try Oracle Cloud Free Tier
Oracle Sustainability
Oracle COVID-19 Response
Oracle and SailGP
Oracle and Premier League
Oracle and Red Bull Racing Honda
Contact Us
US Sales 1.800.633.0738
How can we help?
Subscribe to Oracle Content
Try Oracle Cloud Free Tier
Events
News
© 2025 Oracle
Privacy
/
Do Not Sell My Info
Ad Choices
Careers