Ansicht
Dokumentation

ABENSQL_STRICT_COND_778 - SQL STRICT COND 778

• Use of the function ALLOW_PRECISION_LOSS

• Optional addition window frame specification

• Window functions FIRST_VALUE and LAST_VALUE.

• Use of one of the new date/time functions TSTMPL_TO_UTCL, TSTMPL_FROM_UTCL, DATS_TO_DATN, DATS_FROM_DATN, TIMS_TO_TIMN, TIMS_FROM_TIMN, UTCL_CURRENT, UTCL_ADD_SECONDS, UTCL_SECONDS_BETWEEN, DATN_ADD_DAYS, DATN_ADD_MONTHS, and DATN_DAYS_BETWEEN.

• New additions after the ORDER BY clause: NULLS FIRST and NULLS LAST.

• Use of one of the new aggregate functions MEDIAN, STDDEV, VAR, CORR, and CORR_SPEARMAN.

• New geometry conversion function as_geo_json.

• Subqueries in a relational expression using the operator IN with an operand list.