SQLite Forum

How to implement a table working like a ring buffer
Login
Chronological Hierarchical 
```
(select ID from t where GroupID == o.GroupID and ID > o.ID order by ID limit 1) IS NOT NULL
```
is the same as
```
exists (select ID from t where GroupID == o.GroupID and ID > o.ID order by ID limit 1)
```