Excel SQL 查询括号

Question

我对此Excel SQL查询有问题：

SELECT * 
FROM [RawData$] 
WHERE [Temperature[°C]] <= 100 
AND [Temperature[°C]] > 0 
AND [Sample ID] AND [Freq [Hz]]

我需要知道，如何在查询中使用其他括号，例如"[°C]">

谢谢

PS.：我也尝试过这样的版本，但没有用

SELECT * 
FROM [RawData$] 
WHERE [Temperature[[]°C]] <= 100  
AND [Temperature[[]°C]] > 0 
AND [Sample ID] AND [Freq [[]Hz]]

Answer 1

WHERE "Temperature[c]"<=应该适合你。