Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Help with Duplicate Rows in Candidate Regulations Field — 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

Help with Duplicate Rows in Candidate Regulations Field

Received Response
edited Oct 31, 2016 3:08PM in Reporting and Analytics Taleo Enterprise 4 comments


Looking for a SQL Code to remove duplicate rows



I am using the Candidate Regulations "Race" field to report out hires information. I am finding that some hires have two values in this field .. for example "Race- White" as well as a null value. I would like to ensure I only see 1 row per candidate with the max Race value.  There are also some hires that do not have any information in this field and it comes through as blank (this is okay, but I cannot use the "Race is not null" filter therefore).  I attempted to use the SQL Code below, but it is still removing

Howdy, Stranger!

Log In

To view full details, sign in.


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