select * from emp;
SELECT ENAME, JOB FROM emp;
SELECT ENAME, JOB FROM emp
WHERE SAL BETWEEN 2000 AND 3000;
SELECT * FROM emp
WHERE hiredate like '%1981';
UPDATE emp
Set sal = sal+1000
Where job = 'SALESMAN';
SELECT * FROM EMP;
SELECT ENAME FROM EMP
WHERE ENAME LIKE '%S%';
INSERT INTO EMP VALUES (1002, 'Aguinaldo', 'Manager', NULL, SYSDATE, 5000, NULL, 20);
SELECT * FROM EMP;
SELECT * FROM CUSTOMERS;
SELECT FULL_NAME FROM CUSTOMERS
ORDER BY FULL_NAME DESC;
SELECT AVG(SAL) AS "AVERAGE SALARY" FROM EMP;
SELECT MIN(SAL) AS MINIMUM, MAX(SAL) AS MINIMUM, SUM(SAL) AS TOTAL FROM EMP;
SELECT COUNT(CUSTOMER_ID) FROM CUSTOMERS;
UPDATE EMP
SET JOB = 'SUPERVISOR'
WHERE JOB = 'MANAGER';
SELECT * FROM EMP;]
SELECT * FROM EMP
WHERE JOB = 'SUPERVISOR' AND SAL <= 2500;
SELECT * FROM EMP
WHERE COMM IS NULL;
SELECT * FROM DEPT;
SELECT * FROM EMP, DEPT;
--NATURAL JOIN
SELECT EMPNO, ENAME, DNAME, LOC
FROM EMP NATURAL JOIN DEPT;
--CROSS JOIN
SELECT EMPNO, ENAME, DNAME, LOC
FROM EMP CROSS JOIN DEPT;
SELECT e.empno, e.ename, d.dname, d.loc
FROM emp e LEFT OUTER JOIN dept d
ON (e.deptno=d.deptno);
SELECT e.empno, e.ename, d.dname, d.loc
FROM emp e RIGHT OUTER JOIN dept d
ON (e.deptno=d.deptno);
SELECT e.empno, e.ename, d.dname, d.loc
FROM emp e FULL OUTER JOIN dept d
ON (e.deptno=d.deptno);
Comments