SQLiteForExcel icon indicating copy to clipboard operation
SQLiteForExcel copied to clipboard

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

Open bmtt opened this issue 5 years ago • 1 comments

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.

bmtt avatar May 27 '20 01:05 bmtt

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.

govert avatar Mar 30 '21 07:03 govert