Hacker News new | ask | show | jobs
by itisbiz 3711 days ago
Can I use window functions like partition by?
1 comments

If you connect using a SQL Server instance yes, with the built in database - no, SQLite doesn't have them yet.

I've added some of my own functions to the SQLite engine though, e.g. ElementAt(pos, elements, orderElements) will return the element at position pos in a group, ordered by orderElements. Not exactly window functions, but close.