Question

Consider the emp table and answer all following queries.
1. List all employees’ names and their number.
2. List all the employees’ names and their department number.
3. List employee names and their salary who are working as Analyst.
4. List all the details of the employees whose salary is greater than 2000.
5. List all details of salesman.
6. List employee name , employee number and his hiring date .
7. List employee name, job and salary who are working as ‘SALESMAN’;
8. Find all employees who are working in dept (10,20).
9. List the name and salary all employees’ shoes salary is between 1500 and4000.
10. List the names of all ‘CLERKS’.

Answer 1

1.

select ename,mnumber from employee;

2

select ename,deptno from employee;

3.

select ename,sal from employee where job='ANALYST';

4.

select *From employee where sal>2000;

5.

select *from employee where job='SALESMAN';

6.

select ename,empno,hiredate from employee;

7.

select ename,job,sal from employee where job='SALESMAN';

8.

select *From employee where deptno in(10,20);

9.

select ename,sal from employee where sal between 1500 and 4000;

10.

select ename from employee where job='CLERK';

DON'T FORGET TO LIKE.

THANKS BY HEART.