Web10 sep. 2011 · List the emps who joined before 1981. A) select * from emp where hiredate < (’01-jan-81’); 8. List the Empno, Ename, Sal, Daily sal of all emps in the asc order of Annsal. ... Labels: EMP table, SQL Queries. Newer Post Older Post Home. SEARCH ARTICLES. FREE PROJECTS. CONTENTS WebList the emps who are joined in the year 1981SQL>Select * from emp where hiredate like ‘%81’ ; SQL > Select * from emp where hiredate like ‘ % 81 ’ ; Upload your study docs or become a Course Hero member to access this document Continue to access End of preview. Want to read all 29 pages? Upload your study docs or become a
Tough SQL Queries - Part 2 - Blogger
WebDisplay all the details of all ‘Mgrs’ A)Select * from emp where empno in ( select mgr from emp) ; 7. List the emps who joined before 1981. A) select * from emp where hiredate < (’01-jan-81’); 8. List the Empno, Ename, Sal, Daily sal … Web25. List all Clerks. 26. List all emps joined on 1 may 1981. 27. List the emps whose Salaries are less than 3500. 28. List the emps Empno, Ename, Sal of all emp joined before 1 Apr 1981. 29. List the emps whose exp is more than 10 years. 30. List the emps who are working as Manager. 31. List the emps who are working as clerks and exp is … crafty vape app
SQL Query List the EMPS Who Joined Before a Date - Blogger
Web15 nov. 2024 · Hello Everyone Myself Gautam, In This post i m going to solve 25 SQL Query, 1. Display all the information of the emp table. Ans:- SELECT * FROM EMP; 2. ... List the emps who joined before 1981. Ans:- select * from emp where hiredate < … Web10. List all the employees order by their seniority. 11. List the emps who joined on 1-MAY-81,3-DEC-81,17-DEC-81,19-JAN-80 in asc order of seniority. 12. List all the emps who joined before or after 1981. 13. List the emps who are joined in the year 81. 14. List the emps who are joined in the month of Aug 1980. 15. List the emps those who ... Web19 aug. 2024 · SQL employee Database: Exercise-51 with Solution [An editor is available at the bottom of the page to write and execute the scripts.] 51. From the following table, … crafty vape accessories