Web23 jul. 2024 · List the most senior employee working under the king and grade is more than 3. %%sql select * from emp e where e.hiredate =(select min(e1.hiredate) from emp … Web50.List the emps who are senior to King. A) select * from emp where hiredate < ( select hiredate from emp where ename = 'KING'); 51.List the Emps who are senior to their own MGRS. A) select * from emp w,emp m where w.mgr = m.empno and w.hiredate < m.hiredate ; (OR) B) select * from emp w,emp m where w.empno= m.mgr and w.hiredate> m.hiredate;
1. List the details of the emps whose Salaries more...
WebList the details of the Depts along with Empno, Ename or without the emps 12. List the details of the emps whose Salaries more than the employee BLAKE. 13. List the emps … WebList the employees who have joined on the following dates 1 may 81,17 Nov 81,30 Dec 81 24. List the employees who have joined in the year 1981. 25. List the employees whose annual salary ranging from 23000 to 40000. 26. List the employees working under the Managers 7369,7890,7654,7900. 27. List the employees who joined in the second half … norland show 2022
SQL Queries - SQL-QUERIES Display all the information of the
WebList all the information of emp with Loc and the Grade of all the emps belong to the Grade range from 2 to 4 working at the Dept those are not starting with char set ‘OP’ and not … 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 … Web14 aug. 2024 · List the emps who are either CLERK or ANALYST in the desc order SQL> Select * from emp where job in (CLERK,ANALYST) order by jobdesc ; 015. List the emps who joined on 1May81,31Dec81, 17Dec81, 19Jan80 in asc order of seniority.SQL> how to remove name from messages