SELECT book_title FROM books LIMIT 20, 100;
To retrieve a hundred books starting from the 20th book, you can use the LIMIT clause along with the OFFSET clause in MySQL. Here’s how you can write the query:
SELECT * FROM books
ORDER BY book_id
LIMIT 100 OFFSET 19;
This query will retrieve 100 books starting from the 20th book (OFFSET 19 because SQL indexing typically starts from 0). Replace books with the name of your actual table and book_id with the column that uniquely identifies each book in your database.