Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
BI - CASE statement — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI - CASE statement

Accepted answer
154
Views
22
Comments
edited Mar 17, 2017 12:31PM in Reporting and Analytics for HCM 22 comments

Content

Wondering how we can use the CASE statement in the WHERE clause. I keep getting error 'Missing Keyword'

and I dont see anything wrong with my CASE statement. It starts with CASE, closing with END and I have WHEN and THEN defined in it.

When I use the CASE statement in the SELECT, no issues

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!