Oracle Top 100 Rows. For example top10 would delete the top 10 rows matching the delete criteria. The basic syntax of the top clause with a select statement.
Not all database systems support the select top clause. Its common to run a query using only part of a dataset for example the top 100 salespeople in a company. The following sql statement selects the first three records from the customers table.
If percent is specified then the top rows are based on a topvalue percentage of the total result set as specfied by the percent value.
Viewed 392k times 70 16. The following sql statement selects the first three records from the customers table. Oracle top n queries for absolute beginners. This gives an easy fast way to remove all the rows in a partition.