Neoview SQL Reference Manual (R2.3)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.3 Software

RUNNINGMAX Function..................................................................................................................408

Example of RUNNINGMAX.........................................................................................................408

RUNNINGMIN Function...................................................................................................................408

Example of RUNNINGMIN..........................................................................................................408

RUNNINGRANK Function................................................................................................................410

RUNNINGSTDDEV Function............................................................................................................411

Considerations for RUNNINGSTDDEV.......................................................................................411

Equivalent Result......................................................................................................................411

Examples of RUNNINGSTDDEV..................................................................................................411

RUNNINGSUM Function...................................................................................................................412

Example of RUNNINGSUM..........................................................................................................412

RUNNINGVARIANCE Function........................................................................................................413

Examples of RUNNINGVARIANCE.............................................................................................413

SECOND Function..............................................................................................................................414

Example of SECOND.....................................................................................................................414

SIGN Function.....................................................................................................................................415

Examples of SIGN..........................................................................................................................415

SIN Function.......................................................................................................................................416

Example of SIN..............................................................................................................................416

SINH Function....................................................................................................................................417

Example of SINH...........................................................................................................................417

SPACE Function..................................................................................................................................418

Example of SPACE.........................................................................................................................418

SQRT Function....................................................................................................................................419

Example of SQRT...........................................................................................................................419

STDDEV Function...............................................................................................................................420

Considerations for STDDEV..........................................................................................................420

Definition of STDDEV..............................................................................................................420

Data Type of the Result............................................................................................................420

Operands of the Expression.....................................................................................................420

Nulls.........................................................................................................................................420

FLOAT(54) and DOUBLE PRECISION Data............................................................................420

Examples of STDDEV....................................................................................................................421

SUBSTRING/SUBSTR Function..........................................................................................................422

Alternative Forms..........................................................................................................................422

Considerations for SUBSTRING/SUBSTR.....................................................................................422

Requirements for the Expression, Length, and Start Position.................................................422

Examples of SUBSTRING/SUBSTR...............................................................................................422

SUM Function.....................................................................................................................................424

Considerations for SUM................................................................................................................424

Data Type and Scale of the Result............................................................................................424

Operands of the Expression.....................................................................................................424

Example of SUM............................................................................................................................424

TAN Function......................................................................................................................................425

Example of TAN............................................................................................................................425

TANH Function...................................................................................................................................426

Example of TANH.........................................................................................................................426

THIS Function.....................................................................................................................................427

Considerations for THIS................................................................................................................427

Counting the Rows...................................................................................................................427

Example of THIS............................................................................................................................427

TRANSLATE Function........................................................................................................................428

TRIM Function....................................................................................................................................429

Considerations for TRIM...............................................................................................................429

Result of TRIM..........................................................................................................................429

18 Table of Contents