Notes

2.
Perform the following queries on the
tables just created:
1.
List the names of analysts and salesmen.
SQL>
select ename from emp where job=‟analyst‟ and job=‟salesman‟;
2.
List details of employees who have joined before 30 Sep 81.
SQL> select * from emp where hiredate < ‟30
-
sep
-
81‟;
3.
List names
of employees who are not managers.
SQL> select ename from emp where job is not manager;
4. List the names of employees whose employee numbers are 7369, 7521, 7839,
7934, 7788.
SQL> select ename from from emp where empno in
(7369,7521,7839,7934,7788);
5.
Li
st employees not belonging to department 30, 40, or 10.
SQL> select ename from emp where deptno not in (30,40,10);
6.
List employee names for those who have join
ed between 30 June and 31
Dec.
81.
SQL>
select ename from emp where hiredate between ‟30
-
jun
-
81‟
and ‟31
-
dec
-
81‟;
7.
List the different designations in the company.
SQL> select distinct job from emp;
8.
List the names of employees who are not eligible for commission.
SQL> select ename from emp where comm = NULL;
9.
List the name and designation of the emplo
yee who does not report to
anybody.
SQL> select ename,job from emp where job = „president‟;