List the emps whose jobs are same as allen
WebList the empno, ename, sal, job of the employees with annual sal <34000 but receiving some comm. Which should not be>sal and designation should be salesman working for dept 30. 18. Write an SQL query to List the employees who are working as either mgr or analyst with the salary ranging from 2000 to 5000 and without commission. 19. Web19 aug. 2024 · SQL employee Database: Exercise-46 with Solution. [ An editor is available at the bottom of the page to write and execute the scripts.] 46. From the following table, write a SQL query to find out which employees are working under the managers 63679, 68319, 66564, or 69000. Return complete information about the employees. Sample table: …
List the emps whose jobs are same as allen
Did you know?
Web28 sep. 2024 · 1. QUESTIONS on SUBQUERY 1.DISPLAY ALL THE EMPLOYEES WHOSE DEPARTMET NAMES ENDING 'S' 2.QUERY TO DISPLAY THE EMPLOYEE … WebList the Emps of Grade 3,4 belongs to the dept ACCOUNTING and RESEARCH whose Sal is more than ALLEN and exp more than SMITH in the asc order of EXP. A) ... List the …
Web58.List the emps whose jobs same as SMITH or ALLEN. SELECT*FROM EMP WHERE JOB IN(SELECT JOB FROM EMP WHERE ENAME IN('SMITH','ALLEN')) 59.Write a … Webe job is same as either allen or sal > allenSQL>Se lect * from emp where en ame <> 'ALLEN' 'ALL EN' AND ( AND (j ob = (select job from emp where ename = 'ALLEN') or …
WebList the emps whose Empno not starting with digit78. Ans)SELECT * FROM EMP WHERE EMPNO NOT LIKE ‘78%’; 33. List the emps who are working under ‘MGR’. Ans)select … Web21 jul. 2024 · 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 …
Web19 nov. 2011 · the emps who are either ‘CLERK’ or ‘ANALYST’ in the Desc order. A) select * from emp where job = ‘CLERK’ or job = ‘ANALYST’ order by job desc; List the emps who joined on 1-MAY-81,3-DEC-81,17-DEC-81,19-JAN-80 in asc order of seniority. A) select * from emp where hiredate in (’01-may-81’,’03-dec-81’,’17-dec-81’,’19-jan-80’)
WebList the emps whose Jobs are same as MILLER or Sal is more than ALLEN. SQL> Select * from Emp where job = (select job from emp where ename=’MILLER’) OR Sal > (select … easy bathrooms shower screensWeb15 jul. 2014 · List the Empno, Ename, Sal, Daily sal of all emps in the asc order of Annsal. select empno,ename,sal,sal/30,sal*12 as annsal from emp order by annsal asc 9. Display the Empno, Ename, job, Hiredate, Exp of all Mgrs select empno,ename,job,hiredate,datediff (yy,hiredate,getdate ())as exps from emp where job='manager' 10. cuny calendar spring 2022Web11) Display the names of employees who are working as clerks,salesman or analyst and drawing a salary more than 3000. SQL>select ename from emp where job='CLERK' OR JOB='SALESMAN' OR JOB='ANALYST' AND SAL>3000; 12) Display the names of the employees who are working in the company for the past 5 years; cuny cat math testWeb15 dec. 2024 · List the emps whose jobs same as ALLEN Or SMITH. SQL > Select * from Emp where job in (select distinct job from emp where ename in (‘ALLEN’,’SMITH’)) and ename not in (‘ALLEN’,’SMITH’). 59. Write a Query to display the details of emps whose … cuny careers legalhttp://baskent.edu.tr/~tkaracay/etudio/ders/dbase/sql/htmSQL/OracleDers11.htm cuny business schoolWebYour query is close you need to join using the mgr and the empid. on e1.mgr = e2.empid So the full query is: select e1.ename Emp, e2.eName Mgr from employees e1 inner join … easy bathrooms orpingtonWebSQL>SELECT ENAME FROM EMP WHERE TO_CHAR (HIREDATE,'DD')=DEPTNO 142) Display those employees name as follows A ALLEN B BLAKE SQL> SELECT SUBSTR (ENAME,1,1),ENAME FROM EMP; 143) List out the employees ename,sal,PF (20% OF SAL) from emp; SQL>SELECT ENAME,SAL,SAL*.2 AS PF FROM EMP; easy bathrooms taunton