List the employees who joined after 01/01/82
Web30 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 … Web13.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’;
List the employees who joined after 01/01/82
Did you know?
Web10 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. Web23 okt. 2024 · In order to get result you want, you need a calendar - separate table which contains all months in a year because table with employees doesn't contain all months (see above - nobody was hired in e.g. March). Then you'd outer join that calendar with the original table, count number of employees and - that's it:
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 ... 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 …
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 …
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 …
Web18 jan. 2016 · I want to retrieve the records of employees who were joined in first quarter or in the first month. I have tried this but am not getting the right answer... SELECT * … citrulline with taurineWebSQL Query Interview Questions. 1. Get all employee details from the employee table? 2. Get First_Name, Last_Name from employee table? 3. Get First_Name from employee table using alias name “Employee Name”? citrullus colocynthis adalahWeb13. 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. dicks bowsWeb58.Display all the employees who are joined before the last person 59. 59.Display last but one employee record 60. 60.Find third minimum salary in the employee table 61. 61.Display all the employees who are earning more than any of the manager. 62. List employees who joined after 4 years of 1st employee of the company and less than … dicks boys baseball pantsWeb23 jul. 2024 · List the employees who joined in 1981 with the job same as the most senior person of the year 1981. %% sql select * from emp e where 1981 = extract ( year from e … dicks boys cleatsWeb10 sep. 2011 · 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 … dicks box blindsWeb19 aug. 2024 · SQL employee Database: Exercise-12 with Solution [An editor is available at the bottom of the page to write and execute the scripts.] 12. From the following table, … dicks bowling shoes for men