Tag: Fetch

Oracle Top-N Queries for Absolute Beginners

Oracle Top-N Queries for Absolute Beginners
It’s common to run a query using only part of a dataset – for example, the top 100 salespeople in a company. In this article, we’ll see how to use Oracle’s Top-N query method to query just these rows. Top-N queries retrieve a defined number of rows (top or bottom) from a result set. In other words, they find the best or worst of something – the ten best selling cars in a certain region, the five most popular routers, the 20 worst-performing stores, etc.