govert / SQLiteForExcel

A lightweight wrapper to give access to the SQLite3 library from VBA.
MIT License
260 stars 82 forks source link

How to get SQLite's window functions available since SQLite 3.25? #12

Open bmtt opened 4 years ago

bmtt commented 4 years ago

Hi. I want to use the row_number() window function but it is not available on the latest "SQLite for Excel" bundle from 2016 (SQLite 3.11?). Window functions first appeared on SQLite 3.25, now we are at 3.32.

govert commented 3 years ago

You should be able to update the SQLite binary without any changes to the "SQLite for Excel" helper. That way you'll get the extra built-in functions.