Oracle LIMIT ROWNUM Query Guide

1 year ago
Benjamin Taylor
1 minute

In Oracle, you can achieve functionality similar to LIMIT using ROWNUM and subqueries. For example, you can use the following query to retrieve the first 5 records:

SELECT * 
FROM (
    SELECT * 
    FROM your_table
    ORDER BY your_column
) 
WHERE ROWNUM <= 5;

In this query, the records are first sorted, and then ROWNUM is used to filter out the top 5 records. This allows for a functionality similar to LIMIT.

bannerAds