# Using the Analytic Functions : Introduction « Analytical Functions « Oracle PL/SQL Tutorial

Home
Oracle PL/SQL Tutorial
 1 Introduction 2 Query Select 3 Set 4 Insert Update Delete 5 Sequences 6 Table 7 Table Joins 8 View 9 Index 10 SQL Data Types 11 Character String Functions 12 Aggregate Functions 13 Date Timestamp Functions 14 Numerical Math Functions 15 Conversion Functions 16 Analytical Functions 17 Miscellaneous Functions 18 Regular Expressions Functions 19 Statistical Functions 20 Linear Regression Functions 21 PL SQL Data Types 22 PL SQL Statements 23 PL SQL Operators 24 PL SQL Programming 25 Cursor 26 Collections 27 Function Procedure Packages 28 Trigger 29 SQL PLUS Session Environment 30 System Tables Data Dictionary 31 System Packages 32 Object Oriented 33 XML 34 Large Objects 35 Transaction 36 User Privilege
 Oracle PL/SQL Tutorial » Analytical Functions » Introduction
16.1.3.Using the Analytic Functions

The analytic functions are organized into the following categories:

1. Ranking functions calculate ranks, percentiles, and n-tiles (for example, tertiles, quartiles).
2. Inverse percentile functions calculate the value that corresponds to a percentile.
3. Window functions calculate cumulative and moving aggregates.
4. Reporting functions calculate things like market shares.
5. Lag and lead functions get a value in a row where that row is a certain number of rows away from the current row.
6. First and last functions get the first and last values in an ordered group.
7. Linear regression functions fit an ordinary-least-squares regression line to a set of number pairs.
8. Hypothetical rank and distribution functions calculate the rank and percentile that a new row would have if you inserted it into a table.

Quote from:

Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)

# Paperback: 608 pages

# Publisher: McGraw-Hill Osborne Media; 1st edition (February 20, 2004)

# Language: English

# ISBN-10: 0072229810

# ISBN-13: 978-0072229813

 16.1.Introduction 16.1.1. The Analytical Functions in Oracle (Analytical Functions I) 16.1.2. The Order in Which the Analytical Function Is Processed in the SQL Statement 16.1.3. Using the Analytic Functions 16.1.4. Using the Ranking Functions 16.1.5. More Than One Analytical Function May Be Used in a Single Statement 16.1.6. Calculate with Analytical functions