Question

Write SQL statement that gives the same output as the following SQL

statement but uses “IN” keyword.

SELECT ENAME FROM EMPL WHERE JOB = “CLERK” ;​

Answer 1

SELECT ENAME

FROM EMPL

WHERE JOB IN ('CLERK') ;