I am by no means a SQL expert. I have the following Query:
SELECT ROW_NUMBER ( ) OVER ( ORDER BY “Sequence” ) AS “Row_Number” FROM “Clients”
The table Clients exists and the column Sequence exists in the table. Why am I getting
or more importantly how do I fix it?
HSQLDB Embedded.
Version: 25.8.4.2 (X86_64)
Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df
CPU threads: 14; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Charles