Limit statement in PartiQL - Get Last row

Question

How do I use Limit in PartiQL? What I need is the last 3 rows from the table of Amazon QLDB which uses PartiQL Syntax for querying. Something like SELECT * FROM Accounts where AddedBy = '[email protected]' LIMIT 3

Answer 1

LIMIT isn't currently supported by Amazon QLDB. Here's a more detailed answer to your question Pagination in QLDB.