Web3 dec. 2024 · 7.SQL query to select the employees getting salary greater than the average salary of the department that are working in. SELECT * FROM Employee E1, ( SELECT DEPTNAME, AVG (SAL) SAL FROM Employee GROUP BY DEPTNAME ) E2 WHERE E1.DEPTNAME = E2.DEPTNAME AND E1.SAL > E2.SAL; -----OR SELECT EMPNO, … Web18 apr. 2012 · here deptno value is available in sal column like (30 (deptno) is available in sal (3000),means sal column is containg 30) if any record,which is not matching with this condition, discard it. If you have any queries pls let me know.. Thanks flag Report Was this post helpful? thumb_up thumb_down
SQL: List the department where there are no employees
WebDisplay the department numbers with more than three employees in each dept. select deptno, count (*) from emp group by deptno having count (*)>3; 49. Display the various jobs along with total sal for each of the jobs where total sal is greater than 40000. Web4 feb. 2016 · SELECT d.depNO,d.DNAME,e.EMPNO,e.ENAME FROM EMP e INNER JOIN dept d ON (e.depno = d.depno) WHERE EXISTS (select 1 from EMP t where t.mgr = e.empNO) AND d.depNO in (10,20,30) This will join the tables together, filter only departments 10 20 and 30, and check if for that employee exists another employee that … grass whip vs scythe
Find the number of employees in each department - SQL Oracle
Web[A REFERENCE KEY VALUE WITHOUT A PRIMARY KEY VALUE.] select * from emp where deptno not in (select deptno from dept) 107. List the name, sal, comm. And net pay is more than any other employee. SQL > select empno, sal, comm, sal+sal*1.2+800 Net from emp where sal = (select max (sal) from emp) ; 108. Web3 mei 2024 · There are 4 managers in total 2, 4 , 6 and 3. Here clearly emp_id 2 Zaid is a person whose salary 620 is greater than his manager's salary emp_id 4 which is 600 but less than all other managers emp_id 6 and 3. So I should get that result but getting nothing. Expected result emp_ID emp_Name emp_sal_K emp_manager 2 Zaid 620 4 sql sql … Web21 jul. 2024 · 41. Display the Empno, Ename, Sal, Dname, Loc, Deptno, Job of all emps working at CHICAGO or working for ACCOUNTING dept with Ann Sal>28000, but the Sal should not be=3000 or 2800 who doesn’t belongs to the Mgr and whose no is having a digit ‘7’ or ‘8’ in 3rd position in the asc order of Deptno and desc order of job. chloe susanna boots black