built-in window functions

  1. Jorge M A

    B4J Question [SOLVED] SQLite Built-in Window Functions?

    Why is it not possible to run a query against SQLite that contains functions like row_number() or rank() ? e.g. Dim RS As ResultSet=Sql1.ExecQuery($"SELECT ROW_NUMBER () OVER ( ORDER BY cid ) RowNum, ostatus, cid, itemcount FROM orders;"$) Error in Log: DBeavear and DB Browser for SQLite...
    • Jorge M A
    • Thread
    • built-in window functions rank row_number sql sqlite
    • Replies: 4
    • Forum: B4J Questions
Top