Re: how to find continuous row of same value

[Peter Brawley]

> please do not apply order by on query,
> otherwise we will not get expected result.

Sorry, that's nonsense.

Without an Order By clause, order is undefined and unpredictable. That's a fundamental feature of relational databases: storage order is irrelevant to query results.

So you will need to define an ordering for your query. If you have been counting on order of insert, you will need to add a timestamp column, or a programmed ordering integer, to enforce the desired order.