SELECT select_clause FROM [TD_SYSFNLIB.]APPLY( [ on_clauses ] [ RETURNS table_name | * | ( column_name column_data_type [ {, column_name column_data_type }...]) USING STYLE( 'style' ) APPLY_COMMAND( 'runtime_command' ENVIRONMENT( 'environment_name' ) [ DELIMITER( 'delimiter_character' ) ] [ QUOTECHAR( 'quote_character' ) ] ) [ [AS] alias_name [ ( [ column_name [ {,column_name }... ]])
- on_clause
ON { table_name | view_name | ( query_expression ) } [ AS correlation_name ] [ hash_or_partition_by [ order_by | local_order_by ] ]- hash_or_partition_by
{ { HASH | PARTITION } BY [ order_by | local_order_by ][,...] | PARTITION BY ANY }- order_by
ORDER BY order_by_spec [,...]- local_order_by
ORDER BY local_order_by_spec [,...]- order_by_spec
{ column_name | column_position | sort_expression } [ ASC | DESC ] [ NULLS { FIRST | LAST } ]- local_order_by_spec
localOrderByList [ ASC | DESC ] [ NULLS { FIRST | LAST } ]