AnsweredAssumed Answered

Execute SQL - previous record or previous range of records

Question asked by ultranix on Apr 26, 2014
Latest reply on May 2, 2014 by philmodjunk

Title

Execute SQL - previous record or previous range of records

Post

     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?

Outcomes