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 Paging Through Results

Hasan Ali
Hasan Ali
2,039 Points
Posted by Hasan Ali
Hasan Ali
2,039 Points

Not understanding what the question is asking

Can anyone help me I am not sure if my code is wrong or if i am simply not understanding the question.

1 Answer

Cara Marco
Cara Marco
2,603 Points
Cara Marco
Cara Marco
2,603 Points

Hi Hasan,

The question is asking you to retrieve all columns, sort the list alphabetically by title, and retrieve only ten of those records, BUT it wants those to be records 11-20, not 1-10. In other words, you could imagine it as the "second page of results" if you could only see ten records at a time.

When I did this problem, I also had a bit of trouble getting all the keywords in the right order. I can't see your code, but that may be causing you a problem too.

I tried the following code and it worked.

SELECT * FROM books ORDER BY title LIMIT 10 OFFSET 10;

Jennifer Nordell
seal-mask
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher
Jennifer Nordell
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

Hi there, Cara Marco ! I changed your comment to an answer. This helps keep the boards tidy by marking this question as answered and also allows for voting on your answer. Thanks for helping out in the Community! :sparkles: