Question

Display EmpNo and EName of all employees from the 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));

They can be very useful when you need to select rows from a table with a ... SELECT empno, ename, job ... Write a query to display the employee name and hiredate for all employees in the same department as Blake.