The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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

(16 Mar '16, 09:22) Chris Keating
Be the first one to answer this question!
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:

×128

question asked: 15 Mar '16, 15:27

question was seen: 830 times

last updated: 16 Mar '16, 09:22