Browsing Tag
esproc
6 posts
Essential Adjacent References
Data analysis often involves cross-row calculations, such as Link Relative Ratio (LRR), Year-over-Year (YoY) and moving averages. Implementing…
Querying CSV/XLS and other files:SPL Lightweight Multisource Mixed Computation Practices #2
It is convenient to access files with SPL. The language can also deal with various file formats. Computing…
Simulating Multiple-Layer Loop to Solve Logical Problems
Please write a program to solve the following 10 questions: Which question is the first question with answer…
esProc SPL: Equivalent to the Python-enhanced DuckDB
For desktop data analysis users, if DuckDB is the handy ‘SQL Swiss Army Knife,’ then esProc SPL is…
Get the whole group where at least one member meets the specified condition #eg36
Below is a table queried from BigQuery database. Its 4th field has comma-separated strings. Use Java to do…
Is SQL a declarative language
When learning SQL, we often hear the saying that SQL is a declarative language. You just need to…