Questions Tagged With olap

active newest hottest most voted unanswered

vote

answers

759

views

Count between rows

13 Feb '20, 07:23 Volker Barth39.5k

rowcount olap

votes

answers

4.1k

views

Is predicate push-down prevented for columns of a view used within a view using WINDOW functions?

20 Jul '18, 10:37 Volker Barth39.5k

sa-16 olap view

votes

answers

975

views

Count the number of item at a specific nested depth using SQL

03 May '18, 04:07 Volker Barth39.5k

recursion olap

vote

answer

4.1k

views

How to simulate the LAG/LEAD window functions?

02 Feb '17, 03:59 Volker Barth39.5k

olap window-expression

votes

answers

4.1k

views

Customer Statement: updating a running total per row retuned

12 Sep '16, 15:27 Volker Barth39.5k

olap stored-procedure

votes

answers

4.3k

views

Has the evaluation of OLAP functions in recursive queries changed lately?

19 Mar '14, 16:21 Volker Barth39.5k

sa-12.0.1 recursion olap error-message

votes

answers

2.7k

views

What does this SUM OVER code do?

19 Mar '14, 14:38 Ivan T. Bowman2.8k

olap even-a-cow-knows window-expression

votes

answer

6.5k

views

Adding an identity column in an existing table in Sybase

16 May '13, 05:28 Volker Barth39.5k

olap order ase sql

votes

answer

1.9k

views

How to reference a value from current row in OLAP function

18 May '12, 14:13 Glenn Paulley10.8k

olap

votes

answers

1.9k

views

How to improve performance for aggregated queries.

01 Jan '12, 11:06 Volker Barth39.5k

performance olap

vote

answer

2.0k

views

Top n sales for each person

07 Dec '11, 03:37 Volker Barth39.5k

olap select

vote

answers

3.3k

views

sql windowing functions - how to generate a payment schedule summary

21 Aug '11, 07:01 Kumar262

olap asa-9 sql

vote

answers

7.1k

views

What is the cheapest aggregate function (over a single row)?

17 Aug '11, 09:35 Ivan T. Bowman2.8k

olap optimization sa-12 even-a-cow-knows

vote

answer

2.3k

views

How to GROUP over a large range of numerical values?

17 Jun '11, 04:15 Volker Barth39.5k

group-by olap sa-12

votes

answer

2.5k

views

OLAP with non-linear regression tests

15 Jun '11, 01:43 Glenn Paulley10.8k

olap sa-12

vote

answer

3.6k

views

How to detect and exclude outliers from linear regression?

09 Jun '11, 06:14 Martin8.9k

olap linear-regression sa-12

vote

answers

3.0k

views

How do I determine if two different ORDER BY clauses yield rows in the same order?

30 Sep '10, 07:45 Volker Barth39.5k

performance olap window-expression

votes

answer

2.4k

views

How can I use a non-aggregate function like substraction within a WINDOW function?

26 Sep '10, 10:59 Breck Carter32.5k

window-expression olap

votes

answer

6.8k

views

How can I filter the results of a WINDOW function?

26 Sep '10, 10:53 Breck Carter32.5k

window-expression olap

19questions tagged olap

28answers

Most recently updated questions

posts per page153050

SAP SQL Anywhere

Count between rows

Is predicate push-down prevented for columns of a view used within a view using WINDOW functions?

Count the number of item at a specific nested depth using SQL

How to simulate the LAG/LEAD window functions?

Customer Statement: updating a running total per row retuned

Has the evaluation of OLAP functions in recursive queries changed lately?

What does this SUM OVER code do?

Adding an identity column in an existing table in Sybase

How to reference a value from current row in OLAP function

How to improve performance for aggregated queries.

Top n sales for each person

sql windowing functions - how to generate a payment schedule summary

What is the cheapest aggregate function (over a single row)?

How to GROUP over a large range of numerical values?

OLAP with non-linear regression tests

How to detect and exclude outliers from linear regression?

How do I determine if two different ORDER BY clauses yield rows in the same order?

How can I use a non-aggregate function like substraction within a WINDOW function?

How can I filter the results of a WINDOW function?

Related tags