Other Functions

1

Aggregate functions

Supported.

2

Analytic functions

Supported.

3

Object reference functions

Not supported.

4

Models functions

Not supported.

5

OLAP functions

Not supported.

6

Data cartridge functions

Not supported.

7

User-defined functions

Supported.

1

AVG

Supported.

-

2

CORR

Supported.

-

3

COUNT

Supported.

-

4

COVAR_POP

Supported.

-

5

COVAR_SAMP

Supported.

-

6

CUME_DIST

Supported.

-

7

DENSE_RANK

Supported.

-

8

FIRST

Supported.

The KEEP syntax used in GaussDB is compatible with Oracle Database.

9

GROUPING

Supported.

-

10

LAST

Supported.

The KEEP syntax used in GaussDB is compatible with Oracle Database.

11

LISTAGG

Supported.

-

12

MAX

Supported.

-

13

MEDIAN

Supported.

-

14

MIN

Supported.

-

15

PERCENT_RANK

Supported.

-

16

PERCENTILE_CONT

Supported.

-

17

RANK

Supported.

-

18

REGR_ (Linear Regression)

Supported.

-

19

STDDEV

Supported.

-

20

STDDEV_POP

Supported.

-

21

STDDEV_SAMP

Supported.

-

22

SUM

Supported.

-

23

VAR_POP

Supported.

-

24

VAR_SAMP

Supported.

-

25

VARIANCE

Supported.

-

26

WM_CONCAT

Supported.

-

1

FIRST_VALUE

Supported.

-

2

LAG

Supported.

-

3

LAST_VALUE

Supported.

-

4

LEAD

Supported.

-

5

NTH_VALUE

Supported, with differences.

• Oracle Database: The FROM FIRST|LAST syntax format is supported.
• GaussDB: The FROM FIRST|LAST syntax format is not supported.

6

NTILE

Supported.

-

7

ROW_NUMBER

Supported.

-

8

RATIO_TO_REPORT

Supported.

-