MPLOYEENAME = '李小华' WHERE EMPLOYEEID = 2;
UPDATE EMPLOYEE SET EMPLOYEENAME = '大小华华' WHERE EMPLOYEEID = 3;
UPDATE EMPLOYEE SET COMMISSION = 1000 WHERE EMPLOYEEID = 6;
---DELETE POSITION
DELETE POSITION ;
DELETE POSITION WHERE POSITIONNAME = '组长';
DELETE POSITION WHERE POSITIONID = '02';
---select * from POSITION;
--SELECT EMPLOYEE
SELECT * FROM EMPLOYEE;
SELECT EMP.EMPLOYEEID,EMP.EMPLOYEENAME FROM EMPLOYEE EMP;
SELECT EMP.EMPLOYEEID ID,EMP.EMPLOYEENAME 姓名 FROM EMPLOYEE EMP;
SELECT EMP.EMPLOYEEID ID,EMP.EMPLOYEENAME 姓名 FROM EMPLOYEE EMP WHERE EMP.SALARY = 1500;
---DISTINCT
SELECT DISTINCT EMP.EMPLOYEENAME,EMP.SALARY FROM EMPLOYEE EMP;
----||串联
SELECT EMP.EMPLOYEENAME||'的月薪是'||EMP.SALARY INFO FROM EMPLOYEE EMP;
---算术表达式
SELECT EMP.EMPLOYEEID,EMP.SALARY *12 年薪 FROM EMPLOYEE EMP;
---select * from EMPLOYEE;
---where子句 >
SELECT EMP.EMPLOYEEID,EMP.SALARY FROM EMPLOYEE EMP WHERE EMP.SALARY > 1600;
---BETWTEEIN AND
SELECT EMP.EMPLOYEEID, EMP.SALARY FROM EMPLOYEE EMP WHERE EMP.SALARY BETWEEN 1500 AND 1660;
---IN
SELECT EMP.EMPLOYEENAME,EMP.SALARY FROM EMPLOYEE EMP WHERE EMP.SALARY IN(1399,1600);
---NOT IN
SELECT EMP.EMPLOYEENAME,EMP.SALARY FROM EMPLOYEE EMP WHERE SALARY NOT IN(1600,3000);
---IS NULL
SELECT EMP.EMPLOYEENAME, EMP.SALARY FROM EMPLOYEE EMP WHERE EMP.SALARY IS NULL;
-----IS NOT NULL
SELECT EMP.EMPLOYEENAME, EMP.HIREDATE FROM EMPLOYEE EMP WHERE EMP.HIREDATE IS NOT NULL;
---LIKE
SELECT EMP.EMPLOYEENAME FROM EMPLOYEE EMP WHERE EMP.EMPLOYEENAME LIKE '小%';
SELECT EMP.EMPLOYEENAME FROM EMPLOYEE EMP WHERE EMP.EMPLOYEENAME LIKE '%小%';
SELECT EMP.EMPLOYEENAME FROM EMPLOYEE EMP WHERE EMP.EMPLOYEENAME LIKE '_小%';
SELECT EMP.EMPLOYEENAME FROM EMPLOYEE EMP WHERE EMP.EMPLOYEENAME LIKE '_小_';
---NOT LIKE
SELECT EMP.EMPLOYEENAME FROM EMPLOYEE EMP WHERE EMP.EMPLOYEENAME NOT LIKE '大%';
---AND
SELECT EMP.EMPLOYEENAME,EMP.SALARY FROM EMPLOYEE EMP WHERE EMP.SALARY > 1600 AND EMP.COMMISSION > 900;
---ORDER BY
SELECT EMP.EMPLOYEEID,EMP.EMPLOYEENAME,EMP.COMMISSION FROM EMPLOYEE EMP
ORDER BY EMP.COMMISSION;
SELECT EMP.EMPLOYEEID,EMP.EMPLOYEENAME,EMP.SALARY,EMP.COMMISSION FROM EMPLOYEE EMP
ORDER BY EMP.SALARY,EMP.COMMISSION DESC;
本文出自 “Enthusiasm 10年” 博客