Nilesh Sanyal

Nilesh Sanyal

  • NA
  • 83
  • 35.8k

SQL Query

Aug 16 2013 10:56 PM
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)