Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

Your query needs to retrieve the books 11 through 20 from the database when ordered by title, check the OFFSET

limit data

1 Answer

Ari Misha
Ari Misha
19,274 Points

Hiya Nobody! Lets just say you're creating a web app and working with a back-end language like PHP, and you're doing the pagination of your website. And your boss asked you to retrieve first 30 items(inclusive) from the database(lets consider mysql for this example). And This is what your code should look like:

$sql = "SELECT * FROM Orders LIMIT 30";

Now, she asks you to display the items range from 11 - 20(inclusive) from the database on the web page. Here comes the OFFSET clause to rescue. Here is how your code should look like:

$sql = "SELECT * FROM Orders LIMIT 10 OFFSET 10";

The above SQL query also says "return only 10 records, start on record 11 (OFFSET 10)". I hope it makes sense now. Good Luck! (: