Question

Write a query to display EmpNo and EName of

all employees from table Empl.​

Answer 1

Explanation:

WRITE A QUERY TO DISPLAY THE NAME,JOB,SALARY OF ALL EMPLOYEES WHOSE JOB IS CLERK OR ANALYST AND THEIR SALARY ARE NOT EQUAL TO 1000,3000 OR 5000. SQL> SELECT ENAME,JOB,SAL FROM EMP where (JOB='CLERK' OR JOB='ANALYST') AND (SAL NOT IN (1000,3000,5 000));