Notes

10.
List the employees not assigned to any department.
SQL> select ename from emp where job = NULL;
11.
List the employees who are eligible for commission.
SQL> select e
name from emp where comm. is not NULL;
12.
List employees hose names either start or end with “S”.
SQL> select ename from emp where ename like „S%‟ and like „%S‟;
13.
List names of employees whose names have “i” as the second character.
SQL> select ename from em
p where ename like „_i%‟;
14.
List the number of employees working with the company.
SQL> select ename from emp;
15.
List the number of designations available in the EMP table.
SQL> select distinct job from emp;
16.
List the total salaries paid to the employees.
SQL
> select sum(sal) from emp;
17.
List the maximum, minimum and average salary in the company.
SQL> select max(sal),min(sal),avg(sal) from emp;
18.
List the maximum salary paid to a salesman.
SQL> select max(sal) from emp where job = „salesman‟;