SQL Query

try this


select distinct job from employee

select Empname,job from Employee where Deptno=12 and job='clerk'

select Empname,(salary+isnull(comm,0)) as total_remuneration from employee

select job,min(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.empname,d.deptno, e.salary
from employee e
inner join
(select deptno,min(salary) salary from employee  group by deptno)d
on e.deptno = d.deptno and e.salary= d.salary