Execute SQL - previous record or previous range of records
Hey, this week I upgraded from Filemaker 11 straight to Filemaker 13 and got introduced to amazing function called ExecuteSQL.
I am not very familiar with it's coding yet, but what I've seen from demos is nothing short of amazing.
However, I couldn't find how to SELECT data from previous record or range of previous (let's say, 5, records). For next or upcoming records, there is a:
SELECT * FROM t1 OFFSET 1 ROWS FETCH FIRST 2 ROWS ONLY
But what's the code for previous?