SQL Query

Question

EMPLOYEE(EMPNOEMPNAMEJOBDEPTNOSALARYCOMM) DEPTT(DEPTNODPTNAMELOCATION) SALGRADE(MINSALMAXSALGRADE) 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.

Sanjeeb Lenka · Answer

try this select distinct job from employee select Empnamejob from Employee where Deptno=12 and job='clerk' select Empname(salary+isnull(comm0)) as total_remuneration from employee select jobmin(salary) salary from employee group by job SELECT D.DptName FROM DEPTT D WHERE (SELECT COUNT(*) FROM Employee E WHERE E.Deptno = D.Deptno) > 5 select e.empnamed.deptno e.salary from employee e inner join (select deptnomin(salary) salary from employee group by deptno)d on e.deptno = d.deptno and e.salary= d.salary

Nilesh Sanyal · Answer

Thank you so much.