3 ms·
Can I use window functions like partition by?
by itisbiz 10y ago
Can I use window functions like partition by?
- anakic 10y agoIf 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.