1. List all information of ‘Emp’ and ‘Dept’ tables.
EMP TABLE:
DEPT TABLE:
1. 2. List the empno, ename, jobtitle, and hiredate of employee from the employee table.
EMPNO, ENAME, JOBTITLE, AND HIREDATE
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
SQL Queries on EMP and DEPT Tables, Assignments of Database Management Systems (DBMS)
Various SQL queries to extract information from the EMP and DEPT tables. Queries include listing employee details based on specific conditions, such as job title, hire date, and salary. Additionally, queries are provided to retrieve department details based on location and department number. Some queries involve updating the salary of employees and listing employees with unusual salary conditions.
Typology: Assignments
2020/2021
1 / 5
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download SQL Queries on EMP and DEPT Tables and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!
- List all information of ‘Emp’ and ‘Dept’ tables. EMP TABLE: DEPT TABLE:
- List the empno, ename, jobtitle, and hiredate of employee from the employee table. EMPNO, ENAME, JOBTITLE, AND HIREDATE
- List the name,salary of the employees who are clerks. NAME, SALARY:
- List the name,job,salary of every employee joined on ‘december 17,1980’, Select ENAME, SAL, JOB from emp where HIREDATE='17-DEC-1980';
- List name and annual salary of all the employees. NAME AND ANNUAL SALARY
- List the department name & deptno for departments having deptno.>= DEPARTMENT NAME & DEPTNO
10.11. List the name,salary,commision of the employees where commision is greater than their salary. 11.12. List the name and empno of managers who earn more than 2000.display the result in alphabetical order of the name. 12.13. List the details of the employees in the depts of 10 & 20 in the order of empno.