How to get 100 entries after an entry with a specific uuid?

Question

PostgreSQL

Hello, how can I write a query that can get 100 records after a record with a specific id (uuid), and sorted by createdAt?

id(uid) | value(string) | createdAt(timestamp)

Answer 1

See the creation date of the desired entry, use it as a condition, add sorting and LIMIT.

Answer 2

Use 2 copies of the table. One to get the date by a given UUID, the second to fetch records.

SELECT t1.*
FROM table t1
JOIN table t2 ON t2.uuid = @uuid1 
             AND t1.createdAt > t2.createdAt
ORDER BY createdAt ASC LIMIT 100