SAPHANA学习（6）：SQL Function(E)

/*

63.ESCAPE

ESCAPE_DOUBLE_QUOTES(<value>)

转义双引号

ESCAPE_SINGLE_QUOTES(<value>)

转义单引号

*/

SELECT ESCAPE_DOUBLE_QUOTES('TAB"LE') FROM DUMMY;
SELECT ESCAPE_SINGLE_QUOTES('Str''ing') FROM DUMMY;

/*

64.EXP

EXP(<number>)

自然对数

*/

SELECT EXP (1.0) FROM DUMMY; 

/*

65.EXPRESSION_MACRO

EXPRESSION_MACRO( <expression_macro_alias> )

返回汇总结果

*/

--CREATE VIEW V_TEST_AGGRE AS SELECT * FROM CORRELATIONTABLE WITH EXPRESSION MACROS(AVG("VALUE") AS AVG_VALUE);
--SELECT EXPRESSION_MACRO(AVG_VALUE) FROM V_TEST_AGGRE;