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.

Related articles

No comments

There are still no comments on this article.

Leave your comment...

If you want to leave your comment on this article, simply fill out the next form:




You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong> .