| 函数名 | 出现的 Query |
|---|---|
| ABS | [query47.sql, query53.sql, query57.sql, query63.sql, query89.sql] |
| AVG | [query1.sql, query6.sql, query7.sql, query9.sql, query13.sql, query14.sql, query14.sql, query17.sql, query18.sql, query22.sql, query24.sql, query24.sql, query26.sql, query27.sql, query28.sql, query30.sql, query32.sql, query35.sql, query39.sql, query39.sql, query44.sql, query47.sql, query53.sql, query57.sql, query63.sql, query65.sql, query81.sql, query85.sql, query89.sql, query92.sql] |
| BETWEEN | [query5.sql, query9.sql, query10.sql, query12.sql, query13.sql, query14.sql, query14.sql, query16.sql, query20.sql, query21.sql, query22.sql, query25.sql, query28.sql, query29.sql, query32.sql, query34.sql, query37.sql, query38.sql, query40.sql, query41.sql, query48.sql, query51.sql, query54.sql, query58.sql, query59.sql, query62.sql, query64.sql, query65.sql, query66.sql, query67.sql, query68.sql, query69.sql, query70.sql, query73.sql, query77.sql, query79.sql, query80.sql, query82.sql, query85.sql, query86.sql, query87.sql, query90.sql, query92.sql, query94.sql, query95.sql, query97.sql, query98.sql, query99.sql] |
| CASE | [query39.sql, query39.sql] |
| COALESCE | [query40.sql, query49.sql, query67.sql, query75.sql, query77.sql, query78.sql, query80.sql, query84.sql] |
| CONCAT | [query5.sql, query66.sql, query80.sql, query84.sql] |
| COUNT | [query17.sql, query28.sql] |
| GROUPING | [query27.sql, query36.sql, query70.sql, query86.sql] |
| IN | [query8.sql, query10.sql, query12.sql, query13.sql, query15.sql, query16.sql, query17.sql, query18.sql, query20.sql, query23.sql, query23.sql, query27.sql, query29.sql, query33.sql, query34.sql, query36.sql, query37.sql, query45.sql, query46.sql, query48.sql, query53.sql, query56.sql, query60.sql, query63.sql, query64.sql, query66.sql, query68.sql, query69.sql, query73.sql, query74.sql, query79.sql, query82.sql, query83.sql, query85.sql, query89.sql, query98.sql] |
| INTERNAL_INTERVAL | [query5.sql, query12.sql, query16.sql, query20.sql, query21.sql, query32.sql, query37.sql, query40.sql, query72.sql, query77.sql, query80.sql, query82.sql, query92.sql, query94.sql, query95.sql, query98.sql] |
| ISNOTNULL | [query51.sql, query72.sql, query93.sql, query97.sql] |
| ISNULL | [query44.sql, query72.sql, query76.sql, query78.sql, query97.sql] |
| MAX | [query23.sql, query23.sql, query51.sql] |
| MIN | [query35.sql] |
| RANK | [query36.sql, query44.sql, query47.sql, query49.sql, query57.sql, query67.sql, query70.sql, query86.sql] |
| ROUND | [query2.sql, query78.sql] |
| STDDEV_SAMP | [query17.sql, query29.sql, query35.sql, query39.sql, query39.sql] |
| SUBSTR | [query8.sql, query15.sql, query19.sql, query23.sql, query23.sql, query45.sql, query62.sql, query79.sql, query85.sql, query99.sql] |
| SUM | [query1.sql, query2.sql, query3.sql, query4.sql, query5.sql, query8.sql, query11.sql, query12.sql, query13.sql, query14.sql, query14.sql, query15.sql, query16.sql, query19.sql, query20.sql, query21.sql, query23.sql, query23.sql, query24.sql, query24.sql, query25.sql, query30.sql, query31.sql, query32.sql, query33.sql, query36.sql, query40.sql, query42.sql, query43.sql, query45.sql, query46.sql, query47.sql, query48.sql, query49.sql, query50.sql, query51.sql, query52.sql, query53.sql, query54.sql, query55.sql, query56.sql, query57.sql, query58.sql, query59.sql, query60.sql, query61.sql, query62.sql, query63.sql, query64.sql, query65.sql, query66.sql, query67.sql, query68.sql, query70.sql, query71.sql, query72.sql, query74.sql, query75.sql, query76.sql, query77.sql, query78.sql, query79.sql, query80.sql, query81.sql, query83.sql, query86.sql, query89.sql, query91.sql, query92.sql, query93.sql, query94.sql, query95.sql, query97.sql, query98.sql, query99.sql] |
| TOK_DATE | [query5.sql, query12.sql, query16.sql, query20.sql, query21.sql, query32.sql, query37.sql, query40.sql, query77.sql, query80.sql, query82.sql, query92.sql, query94.sql, query95.sql, query98.sql] |
| TOK_DECIMAL | [query5.sql, query18.sql, query49.sql, query61.sql, query75.sql, query90.sql] |
| TOK_INT | [query54.sql] |
| UPPER | [query24.sql, query24.sql] |
| WHEN | [query2.sql, query4.sql, query9.sql, query11.sql, query21.sql, query31.sql, query34.sql, query36.sql, query40.sql, query43.sql, query47.sql, query50.sql, query51.sql, query53.sql, query57.sql, query59.sql, query62.sql, query63.sql, query66.sql, query70.sql, query72.sql, query73.sql, query74.sql, query86.sql, query89.sql, query93.sql, query97.sql, query99.sql] |
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）