Execute Query working / View Mode shows different value

Execute Query working / View Mode shows different value

Hello,
We have a snapshot setup and I'm trying to return the next to last snapshot id where the data column is set to 'good'

The Table:
Snapshot Id
Data
3
Good
2
Bad
1
Good

So 3 is the newest snapshot, and I'm trying to find 1
When I run the following query..

  1. SELECT DISTINCT
  2. "Trust Building Premier Clients Snapshot"."Snapshot ID" AS 'Previous Good Snapshot Id'
  3. FROM  "Trust Building Premier Clients Snapshot" 
  4. WHERE  "Trust Building Premier Clients Snapshot"."Snapshot ID"  IN
  5. ( 
    1. SELECT "Trust Building Premier Clients Snapshot"."Snapshot ID"
    2. FROM  "Trust Building Premier Clients Snapshot" 
    3. WHERE  "Trust Building Premier Clients Snapshot"."Data State"  = 'Good'
  6. )
  7. ORDER BY "Trust Building Premier Clients Snapshot"."Snapshot ID" DESC 
  8. LIMIT 2
  9. OFFSET 1 
And hit 'Execute Query', the Results Preview returns 1 
When I save it and switch to View Mode, it shows 3

Any idea why they'd be different?
Thanks