Recrusive cte in databrick sql

Databricks143
New Contributor III

Hi Team,

How to write recrusive cte in databricks SQL.

Please let me know any one have solution for this