0% found this document useful (0 votes)

6 views5 pages

Employee Data Queries and Results

The document contains various queries regarding employee details based on specific criteria such as hiring dates, job titles, and departments. It includes results for employees hired between certain years, excluding specific job roles or departments. Additionally, it provides details on employees with particular salary conditions and their annual salaries.

Uploaded by

tanishkrshn

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

6 views5 pages

Employee Data Queries and Results

Uploaded by

tanishkrshn

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

BETWEEN

1] WAQTD NAMES OF AN EMP HIRED AFTER 1981 AND BEFORE

1987.

ENAME
----------
MILLER

2] WAQTD DETAILS OF AN EMP EXCLUDING THE EMP'S WORKING

IN DEPTNO 10 OR 20.

6 rows selected.

3] WAQTD DETILS OF AN EMP EXCEPT PRESIDENT OR MANAGER.

10 rows selected.

4] WAQTD NAMES OF AN EMP WORKING IN DEPTNO 10 OR 20

EXCEPT CLERK OR SALESMAN.

ENAME
----------
JONES
CLARK
SCOTT
KING
FORD

5] WAQTD DETAILS OF EMP EXCLUDING THE EMP'S HIRED IN THE

YEAR 1981.

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO

-------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10

6] WAQTD NAMES OF AN EMP HIRED AFTER 1980 & BEFORE 1987

EXCLUDING THE EMP'S HIRED IN THE YEAR 1982.

10 rows selected.

7] WAQTD NAMES OF AN EMP WORKING AS PRESIDENT OR

ANALYST IN DEPTNO 10 OR 20.
ENAME
----------
SCOTT
KING
FORD
8] WAQTD DETAILS OF AN EMP HIRED IN THE YEAR 1987.

EMPNO ENAME JOB MGR HIREDATE SAL COMM

DEPTNO
------- ---------- --------- ---------- --------- ---------- ---------- ----------
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7876 ADAMS CLERK 7788 23-MAY-87 1100 20

9] WAQTD NAMES OF AN EMP WORKING AS MANAGER OR

ANALYST OR PRESIDENT IN DEPTNO 10 OR 20 & EARNING MORE
THAN 2900.

ENAME
----------
JONES
SCOTT
KING
FORD

10] WAQTD NAMES OF AN EMP WORKING AS A SALESMAN OR

MANAGER IN DEPT NO 10 OR 30 & HIRED IN THE YEAR 1981 &
GETS THE COMMISSION OF 1400.
ENAME
----------
MARTIN

11] WAQTD NAMES OF AN EMP WORKING AS A PRESIDENT OR

SALESMAN OR CLERK IN DEPTNO 10 OR 30 & HIRED AFTER 1980
BEFORE 1983 & EARNS SALARY MORE THAN 3000.

ENAME
----------
KING

12] WAQTD DETAILS OF EMP ALONG WITH ANNUAL SAL IF THE

EMP IS WORKING AS MANAGER OR PRESIDENT IN DEPTNO 10 OR
30 & HIRED IN THE YEAR 1981 & HE GETS THE SALARY 2850RPS.

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO SAL*12

--------- ---------- --------- ---------- --------- ---------- ---------- ---------- ----------
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 34200

Between
No ratings yet
Between
5 pages
BETWEEN
No ratings yet
BETWEEN
5 pages
Employee Data Analysis Queries
No ratings yet
Employee Data Analysis Queries
9 pages
Employee Details and Salaries Report
No ratings yet
Employee Details and Salaries Report
6 pages
Employee Queries and Salary Data
No ratings yet
Employee Queries and Salary Data
4 pages
Sub Query Case 2
No ratings yet
Sub Query Case 2
6 pages
Sub Query Case-1
No ratings yet
Sub Query Case-1
8 pages
Sub Query Case-1
No ratings yet
Sub Query Case-1
8 pages
Employee Salary and Hire Data Queries
No ratings yet
Employee Salary and Hire Data Queries
8 pages
Pseudo Columns
No ratings yet
Pseudo Columns
7 pages
Employee Salary and Department Data
No ratings yet
Employee Salary and Department Data
2 pages
Employee Salary and Record Queries
No ratings yet
Employee Salary and Record Queries
7 pages
Employee Query Examples for SQL
No ratings yet
Employee Query Examples for SQL
2 pages
SQL Queries for Employee Data Analysis
No ratings yet
SQL Queries for Employee Data Analysis
9 pages
Employee Salary and Hire Data Analysis
No ratings yet
Employee Salary and Hire Data Analysis
4 pages
Employee Table Record Count
No ratings yet
Employee Table Record Count
11 pages
Employee and Manager Designations
No ratings yet
Employee and Manager Designations
1 page
DBMS Payroll System SQL Assignments
0% (1)
DBMS Payroll System SQL Assignments
18 pages
Employee Salary and Job Data Summary
No ratings yet
Employee Salary and Job Data Summary
9 pages
SQL Assignment
No ratings yet
SQL Assignment
9 pages
SQL Inner and Self Join Assignment
No ratings yet
SQL Inner and Self Join Assignment
1 page
Co Related
No ratings yet
Co Related
7 pages
Nested Sub Query
No ratings yet
Nested Sub Query
5 pages
PL/SQL Cursors: Explicit & Implicit Examples
No ratings yet
PL/SQL Cursors: Explicit & Implicit Examples
3 pages
SQL Query Examples for Students
No ratings yet
SQL Query Examples for Students
10 pages
Employees Hired Last Year
No ratings yet
Employees Hired Last Year
3 pages
Database Lab 01: SQL Queries Guide
No ratings yet
Database Lab 01: SQL Queries Guide
3 pages
Employee Salary and Job Data Query
No ratings yet
Employee Salary and Job Data Query
13 pages
Employee-Manager Self Join Examples
100% (2)
Employee-Manager Self Join Examples
1 page
SQL Table Creation and Queries Guide
No ratings yet
SQL Table Creation and Queries Guide
43 pages
SQL Queries for Employee Data Analysis
No ratings yet
SQL Queries for Employee Data Analysis
13 pages
SQL Assignments
No ratings yet
SQL Assignments
17 pages
SQL Practice Exercises for Employees
No ratings yet
SQL Practice Exercises for Employees
3 pages
Sub Query Emp MGR
No ratings yet
Sub Query Emp MGR
6 pages
Employee and Department Overview
No ratings yet
Employee and Department Overview
23 pages
SQL Queries for EMP and DEPT Tables
No ratings yet
SQL Queries for EMP and DEPT Tables
6 pages
SQL Queries for Employee Salary Analysis
No ratings yet
SQL Queries for Employee Salary Analysis
2 pages
Oracle SQL Synonyms and Subqueries Guide
No ratings yet
Oracle SQL Synonyms and Subqueries Guide
14 pages
SQL Table Management and Examples
No ratings yet
SQL Table Management and Examples
42 pages
CST - SQL Concepts
No ratings yet
CST - SQL Concepts
4 pages
CST - SQL Concepts
No ratings yet
CST - SQL Concepts
4 pages
Employee Job Queries and Details
No ratings yet
Employee Job Queries and Details
2 pages
Employee Salary and Job Queries
No ratings yet
Employee Salary and Job Queries
2 pages
Employee and Department Data Overview
100% (1)
Employee and Department Data Overview
1 page
Employee Salary Analysis by Department
No ratings yet
Employee Salary Analysis by Department
10 pages
Group by Clause
No ratings yet
Group by Clause
10 pages
SQL Self Join: Employee and Manager Data
No ratings yet
SQL Self Join: Employee and Manager Data
1 page
Employee Salary and Department Queries
No ratings yet
Employee Salary and Department Queries
7 pages
DDL and DML
No ratings yet
DDL and DML
14 pages
Employee Salary and Job Overview
100% (1)
Employee Salary and Job Overview
7 pages
RDBMS Practical Assignment: DEPT & EMP
No ratings yet
RDBMS Practical Assignment: DEPT & EMP
4 pages
Oracle SQL Queries for Employee Data
No ratings yet
Oracle SQL Queries for Employee Data
13 pages
SQL Assignments for EMP and DEPT Tables
No ratings yet
SQL Assignments for EMP and DEPT Tables
2 pages
Employee Data Overview and Details
No ratings yet
Employee Data Overview and Details
2 pages
SQL Database Creation and Queries Guide
No ratings yet
SQL Database Creation and Queries Guide
21 pages
SQL Queries for Employee Data Analysis
No ratings yet
SQL Queries for Employee Data Analysis
8 pages
Employee Data Queries in SQL
No ratings yet
Employee Data Queries in SQL
9 pages
Employee Salary and Hire Date Analysis
No ratings yet
Employee Salary and Hire Date Analysis
1 page
Employee Job and Salary Analysis
No ratings yet
Employee Job and Salary Analysis
5 pages

Employee Data Queries and Results

Uploaded by

Employee Data Queries and Results

Uploaded by

BETWEEN

1] WAQTD NAMES OF AN EMP HIRED AFTER 1981 AND BEFORE

2] WAQTD DETAILS OF AN EMP EXCLUDING THE EMP'S WORKING

3] WAQTD DETILS OF AN EMP EXCEPT PRESIDENT OR MANAGER.

4] WAQTD NAMES OF AN EMP WORKING IN DEPTNO 10 OR 20

5] WAQTD DETAILS OF EMP EXCLUDING THE EMP'S HIRED IN THE

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO

6] WAQTD NAMES OF AN EMP HIRED AFTER 1980 & BEFORE 1987

7] WAQTD NAMES OF AN EMP WORKING AS PRESIDENT OR

EMPNO ENAME JOB MGR HIREDATE SAL COMM

9] WAQTD NAMES OF AN EMP WORKING AS MANAGER OR

10] WAQTD NAMES OF AN EMP WORKING AS A SALESMAN OR

11] WAQTD NAMES OF AN EMP WORKING AS A PRESIDENT OR

12] WAQTD DETAILS OF EMP ALONG WITH ANNUAL SAL IF THE

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO SAL*12

You might also like