隨著

✅ Azure 串流分析 ✅ 網狀架構事件串流

指定查詢中FROM子句可以參考的暫存具名結果集。 這會定義於單一 SELECT 語句的執行範圍內。

備註

WITH 子句在相應放大查詢方面有特殊用途。 如需詳細資訊，請參閱 調整 Azure 串流分析作業

語法

WITH   
  
<result_set_name1> AS  
  ( SELECT_query_definition1 ),  
  
[<result_set_name2> AS  
  ( SELECT_query_definition2 )  
[...n]  ]  
  

論點

result_set_name

這是 SELECT 語句的 FROM 子句可以參考的暫存結果集名稱。 此名稱必須與查詢範圍內定義的任何其他result_set_name名稱不同。

SELECT_query_definition

指定 SELECT 語句，其結果集會填入result_set_name。

範例

WITH   
NormalReadings AS  
(  
  SELECT *  
  FROM Sensor  
  WHERE Reading < 100 AND Reading > 0  
),  
Averages AS  
(  
  SELECT SensorId, AVG(Reading) as AvgNormalReading  
  FROM NormalReadings  
  GROUP BY SensorId, TumblingWindow(minute, 1)  
),  
BadAverages AS  
(  
  SELECT *  
  FROM Averages  
  WHERE AvgNormalReadings < 10  
)  
  
SELECT * INTO outputAlerts FROM BadAverages  
SELECT * INTO outputLog FROM NormalReadings