Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar

Search for    in all of
view all search results right arrow

Support > Technical Documents > Document Types > White Paper-Technical > Analytic Functions in SQL Anywhere

Analytic Functions in SQL Anywhere

This iAnywhere Solutions' White Paper describes the OLAP functions available in the Jasper release of SQL Anywhere.
RSS Feed

Please click here to download the whitepaper.


1 Introduction
2 Group by clause extensions
  2.1 Group by Grouping Sets
    2.1.1 Using the GROUPING() function
  2.2 Group by Rollup and Cube
    2.2.1 Group by Rollup
    2.2.2 Equivalence of Rollup with Grouping Sets
    2.2.3 Group by Cube
3 Statistical aggregate functions
  3.1 Standard deviation and variance
  3.2 Correlation and linear regression
    3.2.1 Goodness-of-fit statistic
    3.2.2 Regression and correlation functions
4 Window functions
  4.1 Defining the window
  4.2 Ranking functions
    4.2.1 The DENSE_RANK() function
    4.2.2 Other ranking functions
  4.3 Numbering rows
  4.4 Window aggregate functions
A BNF Grammar for OLAP Functions

List of Tables

1 Simple aggregate functions
2 Statistical aggregate functions
3 Additional regression measures

List of Figures

1 Schematic of a 3-row moving window with partitioned input
2 Graphical plan for the query in Example 24
3 Graphical plan for the main query block in Example 25
4 Graphical plan for the subquery in Example 25
5 Execution plan of the query from Example 26, using a window function


Last Revised: Dec 09, 2005
Product: SQL Anywhere
Technical Topics: SQL Anywhere, Data Management, Performance & Tuning, SQL Reporting & Analytics Use
Business or Technical: Technical
Content Id: 1037447
Infotype: White Paper-Technical

© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics