mysql - Kusto KQL equivalent to with clause

Question

I'm trying to find an alternative to MySQL (v8) with clause.

I have some long query that uses with clause for aliasing some result.

with top5 as (
        SELECT ....
) 
SELECT .... from top5 
UNION ALL .... from top5

I'm trying to find the equivalent to with clause in Kusto KQL.

Any help would be appreciated.

标签： mysqlazureazure-data-explorerkql

Answer 1

I think the let statement is what you are looking for: https://docs.microsoft.com/en-us/azure/kusto/query/letstatement#using-materialize-function