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.
KRIS NIKOLAISEN54,289 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.