SELECT rank, job_title, department, department_code from hz_org_contacts where department_code is not null or rank is not null or job_title_code is not null
View Text - HTML Formatted
SELECT RANK , JOB_TITLE , DEPARTMENT , DEPARTMENT_CODE FROM HZ_ORG_CONTACTS WHERE DEPARTMENT_CODE IS NOT NULL OR RANK IS NOT NULL OR JOB_TITLE_CODE IS NOT NULL