Skip to content

Snowflake Guide

Eric's another Big Data Blog

Primary Menu
  • Home
  • About Me
  • |
  • SQL
  • Security
  • JDBC

Tag: Recursive

Recursive Query with CTE – How it works

Posted on 19 November 202019 November 2020 by Eric Lin

Recursive query in SQL can be as useful as recursive functions that developers use all the time. Snowflake has documentations on how to use CTE to construct recursive queries. Example can be found here: Working with CTEs. It uses a simple company employees hierarchy to demonstrate how to run recursive queries, and it also describes […]

Continue Reading
Eric Lin
Principal Cloud Support Engineer
@ Snowflake
Blogger | Runner | Ex-Cloudera
3 x SnowPro
Snowflake | Monash University
View Profile

Friendly Links

  • Cloudera Troubleshooting
  • RAYNIX 筆記

Recent Posts

  • How to Merge Variant columns in Snowflake
  • SQLCODE returns 0 in the catch block even the query failed due to invalid identifier
  • String object in Javascript UDF does not have the replaceAll() function
  • Create View Automatically From VARIANT Columns
  • Find Child Queries of a Stored Procedure
All rights reserved!
Copyright All rights reserved | Theme: Advance Blog by WPinterface.