HomeНаука и техникаRelated VideosMore From: OracleDBVision

Oracle Database 12c: Easy Top N and Pagination Queries

12 ratings | 3669 views
Pagination queries using the row limiting clause to fetch N rows or a percentage of rows in a table. For more information, see [Limiting SQL Rows](http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DWHSG9188), [row_limiting_clause](http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF55636).
Html code for embedding videos on your blog
Text Comments (2)
Quick question: what about the cost and cardinality between using offset and rownum (classic paginated)? Thanks
Sandokan Dias (3 years ago)
Thanks! \0/

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.