Oracle: Fetch First 100 Records

1 year ago
Benjamin Taylor
1 minute

In Oracle database, you can use the following SQL statement to retrieve the first 100 records:

SELECT *
FROM (SELECT * 
      FROM your_table
      ORDER BY your_column
      FETCH FIRST 100 ROWS ONLY);

In the example above, replace your_table with the name of the table you want to query and replace your_column with the column you want to sort by. This query will retrieve the top 100 rows in the order of the specified column.

bannerAds