1 個回答
- 最新
- 最多得票
- 最多評論
0
As far as I understood, your requirement is to use more than one condition in case when. I have tested on my account and I was able to observe that we can use multiple boolean statements with CASE WHEN. Therefore, as far as I know, the query that you mentioned must be working fine without any troubles. I would like to know more details about your issue. Is it that the query is failing with any error? If yes, please share the error message. Else, what boolean statements you would like to convert into CASE WHEN?
These links - might probably be helpful:
- https://stackoverflow.com/questions/64803615/how-could-i-use-sql-case-when-correctly-in-athena
- https://stackoverflow.com/questions/14630984/how-do-i-do-multiple-case-when-conditions-using-sql-server-2008
If you require in depth analysis and help with respect to this issue then I would suggest you to raise a support case with AWS premium support team.
相關內容
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前