Given the following statement: SELECT last_name,job_id FROM employees WHERE job_

Question

Given the following statement:
SELECT last_name,job_id FROM employees WHERE job_id NOT IN (‘ST_CLERK’,’ST_MAN’,’SA_REP’);
Change it to another SQL statement using ‘OR’ or ‘AND’ or a combination of the two to produce the same result that the above statement would produce. 6. Given the following statement: SELECT last name, job id FROM employees WHERE JOB id NOT IN ('ST CLERK ST MAN, SA REP) Change it to another SQL statement using 'OR' or 'AND' or a combination of the two to produce the same result that the above statement would produce.

Explanation / Answer

SELECT last_name,job_id FROM employees WHERE job_id NOT IN (‘ST_CLERK’,’ST_MAN’,’SA_REP’); WHERE job_id NOT IN (‘ST_CLERK’,’ST_MAN’,’SA_REP’); means job_id should not be equal to any of these values (‘ST_CLERK’,’ST_MAN’,’SA_REP’), So, the above query can be written as, WHERE job_id NOT IN (‘ST_CLERK’,’ST_MAN’,’SA_REP’); means job_id should not be equal to any of these values (‘ST_CLERK’,’ST_MAN’,’SA_REP’), So, the above query can be written as, SELECT last_name,job_id FROM employees WHERE job_id != ‘ST_CLERK’ and job_id != ’ST_MAN’ and job_id != 'SA_REP’; If there is anything that you do not understand or need more help with, then please mention it in the comments section, SELECT last_name,job_id FROM employees WHERE job_id != ‘ST_CLERK’ and job_id != ’ST_MAN’ and job_id != 'SA_REP’; If there is anything that you do not understand or need more help with, then please mention it in the comments section,

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.