row_number

  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...
Top