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

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 

 
 
CLICK TO EXPAND NAVIGATION
CLICK TO EXPAND NAVIGATION
 
 
 
 
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.

Contents

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
 
References

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

 

DOCUMENT ATTRIBUTES
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