User Tools

Site Tools


oracle:sql:table:list_top_n_rows_of_a_table_in_order

Oracle - SQL - Table - List top n rows of a table in order

SELECT * FROM (SELECT * FROM t ORDER BY c) WHERE ROWNUM <= n;
oracle/sql/table/list_top_n_rows_of_a_table_in_order.txt · Last modified: 2021/08/08 18:15 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki