Query Order Condition

I’m trying to configure a query with the following condition, but Wappler does not accept it
How to do?

ORDER BY date DESC LIMIT 0,1

Hi,
What are you trying to achieve and what have you added to query builder as conditions?

I’m trying to reproduce with Wappler some recordsets made with DW with this condition

ORDER BY date DESC LIMIT 0,1
or
ORDER BY date DESC LIMIT 1,1
or
ORDER BY date DESC LIMIT 2,1

to extract positioned records (last, second to last, third last, …)

you can set a limit clause use a page query and set limit to 1 then it should be possible

1 Like

It’s true, in the meantime I had already managed to understand
Thank you