Tag Archives: With Ties in Oracle

TOP N and Pagination in Oracle 12c

Other than Oracle, most of OLTP Databases already had set of SQL syntax for fetching Top N. In Oracle Database 12c includes support for the ANSI-standard FETCH FIRST/NEXT and OFFSET clauses—together called the row limiting clause. Syntax for the same … Continue reading

Rate this:

Posted in Oracle 12c New Features | Tagged , , , | 3 Comments