| View previous topic :: View next topic |
| Author |
Message |
taecap2u
Newbie
Joined: 03 Aug 2012
Posts: 1
Location: Buffalo NY
|
 Posted: Fri Aug 03, 2012 9:03 am Post subject: SQL Row() function, is it missing or am I missing something? |
 |
|
I need to generate a report with line numbers on it.
This will be used in a medical receipts reimbursement system.
I have attempted to use the ROW_NUMBER() option but get a syntax
SELECT ROW_NUMBER() OVER (ORDER BY "Date") AS "ROWNUM", "Date" as "date", "ServiceProvider" FROM "Receipts"
Any ideas?
Tom |
|
| Back to top |
|
 |
Arineckaig
OOo Advocate
Joined: 01 Mar 2004
Posts: 332
|
| Posted: Fri Aug 03, 2012 9:31 am Post subject: |
|
|
Welcome to the forum.
What database back-end are you using with Base? I understand ROW_NUMBER() OVER is available for DB2, Oracle and SQL Server, but I do not know which other DBMS may now have a similar function: the embedded HSQLDB 1.8 does not so far as I know.
_________________
When this issue has been resolved, it helps other users of the forum if you add the word [Solved] to the Subject line of your 1st post (edit button top right).
OOo 3.4.1 and MySQL on MS Windows XP and Ubuntu |
|
| Back to top |
|
|
|
