2
Reply

SQL Query

Nilesh Sanyal

Nilesh Sanyal

Aug 16 2013 10:56 PM
831
EMPLOYEE(EMPNO,EMPNAME,JOB,DEPTNO,SALARY,COMM)
DEPTT(DEPTNO,DPTNAME,LOCATION)
SALGRADE(MINSAL,MAXSAL,GRADE)

1)Display all different job types
2)List names and jobs of all clerks in department 12
3)Show EMONAME and total remuneration of all employees
4)Calculate and show minimum salary for each different job.
5)Find all departments which have more than 5 empoyees
6)Find the employees who earn the lowest salary in their department.

Answers (2)