Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Reporting with SQL Ordering, Limiting and Paging Results Practice Session

Posted by Joseph Fox
Joseph Fox
3,648 Points

Why am I having to set the values like this to display ID 700 - ID 720?

-- Obtain the actor records between the 701st and 720th records using only LIMIT and OFFSET -- N.B Due to actors being removed from the database the 701st row has the id of 702

SELECT name, id from actors LIMIT 21 OFFSET 699;

THIS RETURNS THE CORRECT INFORMATION - but why would my limit not be 20 and offset be 700 ? doest the top of the table count as a row ?