Untitled
unknown
plain_text
a year ago
555 B
4
Indexable
ALTER SESSION SET CURRENT_SCHEMA=HR; SELECT FIRST_NAME, LAST_NAME FROM HR.EMPLOYEES WHERE LAST_NAME LIKE '%a'; SELECT FIRST_NAME, LAST_NAME FROM HR.EMPLOYEES WHERE FIRST_NAME LIKE '_a%' AND EMPLOYEES.SALARY < 5000; SELECT FIRST_NAME, LAST_NAME, SALARY, DEPARTMENT_ID FROM HR.EMPLOYEES WHERE SALARY <3000 OR (SALARY <5000 AND DEPARTMENT_ID = 50); SELECT COUNT(EMPLOYEE_ID) FROM HR.EMPLOYEES; SELECT SUM(SALARY) FROM HR.EMPLOYEES; SELECT Employees.Job_id, FIRST_NAME,LAST_NAME,JOB_TITLE FROM HR.EMPLOYEES, HR.JOBS WHERE EMPLOYEES.JOB_ID = JOBS.JOB_ID;
Editor is loading...