Database lab1

1. MUHAMMAD MU’IZUDDIN BIN HJ MUHSINON SN097083 LAB 1 - DATABASE EXERCISE -> ANSWER QUESTION 1 DESCRIBE DEPARTMENTS; SELECT * FROM departments; -> ANSWER QUESTION 2 SELECT * FROM employees; -> ANSWER QUESTION 3 SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID, HIRE_DATE "STARTDATE" FROM employees; -> ANSWER QUESTION 4 SELECT JOB_ID FROM EMPLOYEES; -> ANSWER QUESTION 5 SELECT EMPLOYEE_ID "Emp#", LAST_NAME "Employee", JOB_ID "Job", HIRE_DATE FROM employees; -> ANSWER QUESTION 6 SELECT LAST_NAME || ' , ' || JOB_ID AS "Employee and Title" FROM employees; -> ANSWER QUESTION 7 SELECT EMPLOYEE_ID || ',' || FIRST_NAME || ',' || LAST_NAME || ',' || EMAIL || ',' || PHONE_NUMBER || ',' || HIRE_DATE || ',' || JOB_ID || ',' || SALARY || ',' || COMMISSION_PCT || ',' || MANAGER_ID || ',' || DEPARTMENT_ID AS "THE_OUTPUT" FROM EMPLOYEES;

Database lab1

Recommended

Recommended

More Related Content

More from Muhd Mu'izuddin

More from Muhd Mu'izuddin (14)

Recently uploaded

Recently uploaded (20)

Database lab1