List the employees who joined after 01/01/82
Weblist the employees who joined after 2 years of first employee of the company and more than blake salary 31.display location of all the employees who reporting to blake select loc from dept where deptno in (select deptno from emp where mgr in (select empno from emp where ename=’blake’)); 32.list all the employees whose job is same as jones and their … Weblist the employees who does not directly report to president,have commission and salary more than max salary of all the clerk without using null or not null 30. list the employees who joined after 2 years of first employee of the company and more than blake salary 31. display location of all the employees who reporting to blake 32.
List the employees who joined after 01/01/82
Did you know?
Web27 nov. 2016 · SQL INTERWIEW QUESTIONS ON SUBQUERIES. 1. List the department names that are having no employees at all. 2. Display all the employees whose job is same as scott. 3. Display scott manager’s manager’s department name. 4. List employees whose job is same as scott and their salary greater than smith’s salary. WebList the employees who joined in 1981 with the job same as the most senior person of the year 1981. A)select * from emp where job in (select job from emp where hiredate in (select min (hiredate) from emp where to_char (hiredate,’YYYY’) =’1981’)); 70. List the most senior empl working under the king and grade is more than 3.
Web29 apr. 2014 · List the emps whose sal is greater than his managers salary A) select * from emp w,emp m where w.mgr = m.empno and w.sal > m.sal; 88. List the grade, EMP name for the deptno 10 or deptno 30 but sal grade is not 4 while they joined the company before ’31-dec-82’. A) select s.grade ,e.ename from emp e,salgrade s where e.deptno in … Web19 aug. 2024 · Oracle Operator: Exercise-12 with Solution. Write query to list the name (first and last name), hire date of all the employees who joined on 1-JUL-2006, 24-MAR …
WebList all the employees who joined after year 80 and having salary is between 2500 and 4000 and also calculate their salary after six months. 200. select all the manager whose salary is more than 2500 and department of 20 or 30. 201. select all the employee whose employee no second digit is 8 ... Also date of joining after 01-JAN-82 and before ... Web27 mrt. 2024 · SQL JOINS on HR Database: Exercise-13 with Solution. 13. From the following tables, write a SQL query to find all employees who joined on or after 1st …
WebList All The Analyst In Dept Number 20 And Having Salary Greater Than 2500. List All The Employees Whose Name Starts With ‘M’ Or ‘J’. List All The Employees With Annual …
Web13. Display the list of employees who have joined the company before 30th June 90 or after 31st dec 90. select * from emp where hiredate between ‘30-jun-1990’ and ‘31-dec-1990’; 14. Display current date. select sysdate from dual; 15. Display the list of users in your database (using log table). select * from dba_users; 16. highlights from daytona 500Web30 dec. 2024 · I want to show employees who joined in each year with a hire_date on the 23 th day of month March. However, when using below SELECT statement it shows only … small plows for garden tractorshighlights from footballWeb13.List the emps along with their Exp and Daily Sal is more than Rs.100. Ans)SELECT EMPNO,SYSDATE-HIREDATE FROM EMP WHERE SAL/30>100. 14.List the emps who are either ‘CLERK’ or ‘ANALYST’ in the Desc order. Ans) SELECT * FROM EMP WHERE LOWER(JOB) = ‘clerk’ OR LOWER(JOB) = ‘analyst’; highlights from bengals win todayWeb27 jun. 2014 · Below is the code to display the details of the employees who have been hired after the employee 'Jack' was hired All of the information is in a single table. My … highlights from england matchWeb24 jan. 2014 · select * from emp where deptno=30 and hiredate<’01-JAN-1982′; 19. DISPLAY THE DETAILS OF EMP WHO EITHER REPORT TO 7698 OR EARN LESS … highlights from football yesterdayWeb10 sep. 2011 · 1 Answer Sorted by: 7 The WHERE part goes after the FROM part. select ename, job, hiredate from emp where hiredate between '20-FEB-81' AND '01-MAY-81' Note that your date literals may not always work if the NLS settings change. It is highly recommended to use to_date () instead. highlights from dallas cowboys game yesterday