Assignment#3
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Assignment#3 as PDF for free.
More details
- Words: 549
- Pages: 2
ASSIONMENT # 3 PERFORM THE FOLLOWING QUERIES 1.
CHANGE THE COLUMN HEADING ENAME INTO YOUR NAME AND DISPLAY IT.
2.
CHANGE THE COLUMN HEADING SAL INTO SALARIES.
3.
CHANGE THE COLUMN HEADING EMPNO INTO 'EMPLOYEE NAME'.
4.
CHANGE THE COLUMN HEADING JOB INTO DESIGNATION.
5.
CHANGE THE COLUMN HEADING DNAME INTO 'DEPARTMENT NAME'.
6.
CHANGE THE COLUMN HEADING LOC INTO CITIES.
7. CHANGE THE COLUMN HEADING ENAME INTO 'EMPLOYEE NAME' AND JOB INTO DESIGNATION. 8.
CHANGE THE COLUMN HEADING MIN(SAL) AS LO-SAL AND MAX(SAL) AS HI-SAL.
9.
CHANGE THE COLUMN HEADING SAL INTO 'MONTHLY SALARY.
10.
LIST ALL EMPLOYEES AND ADD 20 RUPEES IN EACH SALARY.
11.
LIST ALL 'MANAGER' AND ADD 100 RUPEES IN EACH SALARY.
12.
LIST ALL 'SALESMAN AND ADD 500 RUPEES N EACH SALARY.
13.
LIST ALL 'CLERK' AND ADD 50 RUPEES IN EACH SALARY.
14.
LIST ALL 'ANALYST' AND ADD 250 RUPEES IN EACH SALARY.
15.
LIST ALL 'PRESIDENT' AND ADD 1000 RUPEES IN EACH SALARY.
16. LIST ALL EMFLOYEE AND ADD 1000 RUPEES AND SUBTRACT 4500 RUPEES IN EACH SALARY. 17.
LIST ALL EMPLOYEE AND SUBTRACT 500 RUPEES FROM EACH SALARY.
18.
IF EMPLOYEE NAME IS SCOTT THEN ADD 100 RUPEES IN HIS SALARY.
19.
LIST ALL 'MANAGER' AND SUBTRACTING 100 RUPEES FROM THEIR SALARY.
20.
LIST ALL 'SALESMAN' AND SUSTRACT 200 RUPEES FROM THEIR SALARY.
21. LIST ALL EMPLOYEE AFTER ADDING 500 RUPEES, SUBTRACT 300 RUPEES AND DIVIDED BY 100 RUPEES FROM EACH SALARY. 22.
LIST ALL EMPLOYEES AND FIND FIVE PERCENT FROM EACH SALARY.
23.
FIND THE TEN PERCENT OF 'MANAGER' SALARY.
24.
FIND THE TWO PERCENT OF CLERK SALARY.
25.
FIND EIGHT PERCENT OF SALESMEN SALARY.
26.
FIND THE ANNUAL SALARY OF EACH EMPLOYEE.
27.
FIND THE SIX MONTH SALARY OF EACH EMPLOYEE.
28.
FIND THE TWO MONTH SALARY OF EACH MANAGER.
29. MAKE A QUERY IN WHICH ALL THE ARITHMETIC EXPRESSIONS WILL INCLUDE ALL THE RESULT WILL BE REMAIN SAME. 30.
FIND THE DAILY WAGES OF EACH EMPLOYEE.
31.
FIND THE DAILY WAGES OF EACH 'MANAGER.
32.
FIND THE DAILY WAGES OR EACH 'ANALYST�.
33.
DISPLAY THE COLUMN HEADING ANNSAL INSTEAD OF SAL*12.
34.
COMBINE EMPNO AND ENAME FROM EMP.
35.
COMBINE ENAME AND JOB FROM EMP.
36.
COMBINE ENAME, JOB AND SALARY FROM EMP.
37.
COMBINE EMPNO AND ENAME. THEN CHANGE THE COLUMN HEADING AS EMPLOYEE.
38.
JOIN ENAME AND JOB. THEN CHANGE THE COLUMN HEADING AS COMP_NAME.
39.
LIST ALL RECORDS AS FOLLOWS.
SMITH IS CLERK AND HE IS WORKING IN DEPT NO 20 SINCE 12-MAR-1981. 40.
LIST ALL RECORDS AS FOLLOWS. SCOTT IS AN ANALYST OF DEPTNO 20.
41.
LIST ALL RECORD AS FOLLOWS. THE SALARY OF SMITH IS 800.
42. LIST ALL RECORDS AS FOLLOWS ACCOUNTING IS THE DEPARTMENT IN NEWYORK AND DEPT NO 10. 43.
FIND ANNUAL SALARY AND ADD COMM OF ALL EMPLOYEES.
44. DISPLAY ANNUAL SALARY AND ADD COMM OF ALL EMPLOYEE USING NULL VALUES FUNCTION AND CHANGE THE COLUMN HEADING ANNUAL_SALARY. 45.
LIST ALL DISTINCT DEPARTMENT NUMBER FROM EMP TABLE.
46.
DISPLAY DISTINCT VALUE OF DEPARTMENT NUMBER AND JOBS.
47. LIST ALL EMPLOYEES WHO ARE NOT ELIGIBLE FOR RECEIVING COMMISSION AND ARE 'MANAGER'. 48.
LIST ALL EMPLOYEES WHO ARE ELIGIBLE OF RECEIVING COMMISSION.
49.
LIST ALL DISTINCT JOBS FROM THE TABLE EMP.
50.
HOW MANY JOBS DO WE HAVE.
THE END.
CHANGE THE COLUMN HEADING ENAME INTO YOUR NAME AND DISPLAY IT.
2.
CHANGE THE COLUMN HEADING SAL INTO SALARIES.
3.
CHANGE THE COLUMN HEADING EMPNO INTO 'EMPLOYEE NAME'.
4.
CHANGE THE COLUMN HEADING JOB INTO DESIGNATION.
5.
CHANGE THE COLUMN HEADING DNAME INTO 'DEPARTMENT NAME'.
6.
CHANGE THE COLUMN HEADING LOC INTO CITIES.
7. CHANGE THE COLUMN HEADING ENAME INTO 'EMPLOYEE NAME' AND JOB INTO DESIGNATION. 8.
CHANGE THE COLUMN HEADING MIN(SAL) AS LO-SAL AND MAX(SAL) AS HI-SAL.
9.
CHANGE THE COLUMN HEADING SAL INTO 'MONTHLY SALARY.
10.
LIST ALL EMPLOYEES AND ADD 20 RUPEES IN EACH SALARY.
11.
LIST ALL 'MANAGER' AND ADD 100 RUPEES IN EACH SALARY.
12.
LIST ALL 'SALESMAN AND ADD 500 RUPEES N EACH SALARY.
13.
LIST ALL 'CLERK' AND ADD 50 RUPEES IN EACH SALARY.
14.
LIST ALL 'ANALYST' AND ADD 250 RUPEES IN EACH SALARY.
15.
LIST ALL 'PRESIDENT' AND ADD 1000 RUPEES IN EACH SALARY.
16. LIST ALL EMFLOYEE AND ADD 1000 RUPEES AND SUBTRACT 4500 RUPEES IN EACH SALARY. 17.
LIST ALL EMPLOYEE AND SUBTRACT 500 RUPEES FROM EACH SALARY.
18.
IF EMPLOYEE NAME IS SCOTT THEN ADD 100 RUPEES IN HIS SALARY.
19.
LIST ALL 'MANAGER' AND SUBTRACTING 100 RUPEES FROM THEIR SALARY.
20.
LIST ALL 'SALESMAN' AND SUSTRACT 200 RUPEES FROM THEIR SALARY.
21. LIST ALL EMPLOYEE AFTER ADDING 500 RUPEES, SUBTRACT 300 RUPEES AND DIVIDED BY 100 RUPEES FROM EACH SALARY. 22.
LIST ALL EMPLOYEES AND FIND FIVE PERCENT FROM EACH SALARY.
23.
FIND THE TEN PERCENT OF 'MANAGER' SALARY.
24.
FIND THE TWO PERCENT OF CLERK SALARY.
25.
FIND EIGHT PERCENT OF SALESMEN SALARY.
26.
FIND THE ANNUAL SALARY OF EACH EMPLOYEE.
27.
FIND THE SIX MONTH SALARY OF EACH EMPLOYEE.
28.
FIND THE TWO MONTH SALARY OF EACH MANAGER.
29. MAKE A QUERY IN WHICH ALL THE ARITHMETIC EXPRESSIONS WILL INCLUDE ALL THE RESULT WILL BE REMAIN SAME. 30.
FIND THE DAILY WAGES OF EACH EMPLOYEE.
31.
FIND THE DAILY WAGES OF EACH 'MANAGER.
32.
FIND THE DAILY WAGES OR EACH 'ANALYST�.
33.
DISPLAY THE COLUMN HEADING ANNSAL INSTEAD OF SAL*12.
34.
COMBINE EMPNO AND ENAME FROM EMP.
35.
COMBINE ENAME AND JOB FROM EMP.
36.
COMBINE ENAME, JOB AND SALARY FROM EMP.
37.
COMBINE EMPNO AND ENAME. THEN CHANGE THE COLUMN HEADING AS EMPLOYEE.
38.
JOIN ENAME AND JOB. THEN CHANGE THE COLUMN HEADING AS COMP_NAME.
39.
LIST ALL RECORDS AS FOLLOWS.
SMITH IS CLERK AND HE IS WORKING IN DEPT NO 20 SINCE 12-MAR-1981. 40.
LIST ALL RECORDS AS FOLLOWS. SCOTT IS AN ANALYST OF DEPTNO 20.
41.
LIST ALL RECORD AS FOLLOWS. THE SALARY OF SMITH IS 800.
42. LIST ALL RECORDS AS FOLLOWS ACCOUNTING IS THE DEPARTMENT IN NEWYORK AND DEPT NO 10. 43.
FIND ANNUAL SALARY AND ADD COMM OF ALL EMPLOYEES.
44. DISPLAY ANNUAL SALARY AND ADD COMM OF ALL EMPLOYEE USING NULL VALUES FUNCTION AND CHANGE THE COLUMN HEADING ANNUAL_SALARY. 45.
LIST ALL DISTINCT DEPARTMENT NUMBER FROM EMP TABLE.
46.
DISPLAY DISTINCT VALUE OF DEPARTMENT NUMBER AND JOBS.
47. LIST ALL EMPLOYEES WHO ARE NOT ELIGIBLE FOR RECEIVING COMMISSION AND ARE 'MANAGER'. 48.
LIST ALL EMPLOYEES WHO ARE ELIGIBLE OF RECEIVING COMMISSION.
49.
LIST ALL DISTINCT JOBS FROM THE TABLE EMP.
50.
HOW MANY JOBS DO WE HAVE.
THE END.
Related Documents
Assignment3.docx
May 2020 20
Cs162056-assignment3.docx
December 2019 18
Assignment3 (1).docx
May 2020 9