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.