Limit & offset functionality in mySql, PostgreSQL
One of the excellent features provided by both my mySql & Postgre is support for Limit and offset functionality.
Usage syntax
SELECT <select_list>
FROM <table_expression>
[LIMIT { number | ALL }] [OFFSET number]
This is a useful feature when implementing pagination!
unfortunately this functionality is not currently being supported by Oracle!
Written by Ravi Nallakukkala on July 5th, 2007 with no comments.
Read more articles on Database.