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 = 'admin@demo.com' LIMIT 3
2 Answers
LIMIT isn't currently supported by Amazon QLDB. Here's a more detailed answer to your question Pagination in QLDB.
Limit is now supported in the ExecuteStatement command. See the AWS documentation for sending it as part of the request.
Here is the announcement from March 8, 2022.
Related