The following piece of code does its job : it gives me the top 10 results for each category. SELECT * FROM ( SELECT *, RANK() OVER (PARTITION BY “pera_id” ORDER BY “surface” DESC) …
Tag: spatialite
Sqlite no results for query with a bound parameter, works with identical query with hardcoded value
I am coming up against a strange problem with Sqlite 3. I have a relatively simple query that takes a bound parameter in its WHERE predicate. When executing the query with the bound parameter, I get 0 …