pf » Tag: limit on Pete Freitag's Blog
August 29, 2005
LIMIT and OFFSET SQL Pagination
Both MySQL and PostgreSQL support a really cool feature called OFFSET that is usually used with a LIMIT clause.The LIMIT clause is used to limit the number of results returned in a SQL statement.
April 18, 2003
Returning TOP N Records
Returning only the first N records in a SQL query differs quite a bit between database platforms.
Subscribe to my RSS Feed: 
RSS
RSS
Pete Freitag is a software engineer, and web developer located in central new york.
Pete's company Foundeo Inc. builds products for web developers and provides consulting services.
In 2003 Pete published the ColdFusion MX Developers Cookbook with SAMs Publishing.
More about Pete.
Use SoloSub to subscribe to my RSS feed using Bloglines, MyYahoo, NewsGator, and more.