Lets suppose we are building a blog and wants to implement and get next and previous navigation buttons on the article. Lets suppose that the ID of current article is 5 and for previous navigation it will be 4 and for next article it will be 6 (if the IDs are in this order).
The query to fetch the IDs are:
SELECT * FROM blogs WHERE id = ( SELECT MIN(id) FROM blogs WHERE id > 5 )
SELECT * FROM blogs WHERE id = ( SELECT MAX(id) FROM blogs WHERE id < 5 )
There may be a case that you don’t have the ID 4 exists in the database, but do not worry about it as the query will fetch the available existing record.