SQLite Forum

2 queries asking the same, give different answers
Login
What is the query plan for each of the three queries? Do they all use the same index?

Alternatively, by chance, is there a mix of numeric and textual data in fld0? And what is fld0's declared type? Since text is "greater than" numeric, do you have the case where the max for the whole table is a string, whereas the max for only a limited subset is a number?