Practice 4 - -----------------MILLER CLERK ACCOUNTING 1300...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
\\homeserver\STUDENT-Homefolder\Students Assignment\Batch 2008- 10\Semester II\ITBM\RDBMS using Oracle Practice 4 – SQL 1. Write a query to display the name, department number, and department name for all employees 2. Create a unique listing of all jobs that are in department 30. 3. Write a query to display the employee name, department name, and location of all employees who earn a commission. 7. Modify p4q6.sql to display all employees including King, who has no manager. Resave as p4q7.sql. Run p4q7.sql 8. Create a query that will display the employee name, department number and all the employees that work in the same department as agiven employee. Give each column appropriate label. 9. Show the structure of the SALGRADE table. Create a query that will display the name, job, department name, salary, and grade for all employees Name Null? Type ---------- ---------- --------- GRADE NUMBER LOSAL NUMBER HISAL NUMBER ENAME JOB DNAME SAL GRADE ----------- ------- ------------
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: -----------------MILLER CLERK ACCOUNTING 1300 2 10. Create a query to display the name and the hire date of any employee hired after employee Blake. 11. Display all employees names and hire dates along with their managers name and hire date for all employees who were hired before their managers. Label the columns Employee, Emp Hiredate, Manager, and Mgr Hiredate, respectively. Employee Emp Hiredate Manager Mgr Hiredate------------ ----------------- ----------- -----------------ALLEN 20-FEB-81 BLAKE 01-MAY-81 12. Create a query that displays the employees name and the amount of the salaries of the employees is indicated through asterisks. Each asterisk signifies a hundred dollars. Sort the data in descending order of salary. Label the column EMPLOYEE_AND_THEIR_SALARIES-------------------------------------------------- KING ***************************************** FORD **********************...
View Full Document

This note was uploaded on 01/29/2012 for the course INTERNATIO 101 taught by Professor Mr.johnnash during the Spring '11 term at Symbiosis International University.

Page1 / 2

Practice 4 - -----------------MILLER CLERK ACCOUNTING 1300...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online