Select and Return Top N Rows from Oracle Database
Posted by baobab under SQL SELECT
We often need to limit the number of rows returned by a select statement. Some database servers provide extensions to the select statement. For example, MySql database sever provides LIMIT directive. In Oracle Database each result set has defined a ROWNUM pseudocolumn and ORDER BY clause interact. Read the rest of this entry »
