Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Is that possible to use a combination of Ultralite functions to have a column in the data set with the current row number, like the SQLServer ROW_NUMBER() function does?

asked 15 Mar '16, 15:27

Alex's gravatar image

Alex
1.1k274756
accept rate: 25%

FWIW, SQL Anywhere itself also supports the ROW_NUMBER() OLAP function (and offers way more features w.r.t. to OLAP windows/partitions compared to MS SQL AFAIK. However, I do not know whether OLAP support is available with UltraLite, too.

(15 Mar '16, 17:02) Volker Barth
Replies hidden

Unfortunately not available for Ultralite.

(16 Mar '16, 07:47) Alex

UltraLite does not support OLAP functionality.

permanent link

answered 16 Mar '16, 09:22

Chris%20Keating's gravatar image

Chris Keating
7.8k49129
accept rate: 31%

converted 05 Jul '17, 14:45

@Chris Keating Can you convert it to an answer so I can close this question?

(13 Mar '17, 14:26) Alex
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×162

question asked: 15 Mar '16, 15:27

question was seen: 12,779 times

last updated: 05 Jul '17, 14:34