Databases Reporting with SQL Ordering, Limiting and Paging Results Paging Through Results

SQL Help

In a library database there's a books table. There's a title, author, genre and first_published column.

The library database is connected to a website displaying 10 books at a time, sorted by the title alphabetically.

Write a query to bring back the second page of results. Please retrieve all columns of information.

plz help me with this query.

3 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 50,936 Points

So you want to use limit and offset:

SELECT * FROM books ORDER BY title LIMIT 10 OFFSET 10

thanks for responding kris ,but its not woking. showing bummer like (you should try writing select query).

i did copy paste exactly but still not working.