SQLite Forum

Can this SQL be simplified?
Login
Chronological Hierarchical 
```
    select id from T2
        order by mydate desc
        limit -1
        offset (select maxrows from T1);
```