仅选择ID高于符合特定条件的最后一行的行？

Question

Let's say I have a SQLite 3 database that looks something like this:

ID    COMMAND     MESSAGE
------------------------------------------
1     start       abc
2     foo         xyz
3     bar         123
4     start       Hello
5     xxx         World
6     yyy         !

I want to select only the rows after (and including) the last start command, i.e.

4     start       Hello
5     xxx         World
6     yyy         !

Is this possible to do with pure SQLite, or should I do this in the application code (which is PHP)?

Answer 1

You can use a subquery to get the id for the last start and then use that for filtering:

select t.*
from t
where t.id >= (select max(t2.id) from t t2 where t2.command = 'start');