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

Nancy Melucci
PLUS
Nancy Melucci
Courses Plus Student 36,143 Points
Posted by Nancy Melucci
Nancy Melucci
Courses Plus Student 36,143 Points

You should try writing a SELECT query

Here is my query. I do not understand why I am getting the above error message...

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

thanks...

Vittorio Somaschini
Vittorio Somaschini
33,371 Points
Vittorio Somaschini
Vittorio Somaschini
33,371 Points

Hello Nancy.

I have reformatted your code so that it looks nicer.

Regarding the question, can you point us to the right code challenge so that we can have a look?

Vitto

Nancy Melucci
Nancy Melucci
Courses Plus Student 36,143 Points
Nancy Melucci
Nancy Melucci
Courses Plus Student 36,143 Points

Thanks. You know it was such a brain itch that I spent another 10 minutes and got it figured out (I needed to add the column info). I appreciate your responses - gratitude.

1 Answer

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 91,253 Points
Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points

One thing I can suggest is you try and select specific columns but the line of SQL code here is valid code and would return results.