SQLite Forum
Can this simple query be optimized?
Login
☰
About
Threads
Post
Subscribe
SQLite
Chronological
Hierarchical
Unformatted
History
Easy: ``` SELECT (x/10), min(y), max(y) FROM foo GROUP BY (x/10) ``` [Edit: corrected (x/10) column]