--简单查询SELECT*FROM dept;--基本查询SELECT*FROM dept d;--表的别名SELECT ROWID,deptno,dname FROM dept;--查询指定列SELECT deptno*100FROM emp;--带有表达式的查询SELECT e.empno 员工编号,e.ename 员工名字 FROM emp e;--为列指定别名的查询SELECTDISTINCT job FROM emp e;--查询不重复记录SELECT emp.ename 员工名字,emp.sal+NVL(emp.comm,0) 员工总工资 FROM emp;--处理NULL值的NVL函数SELECT e.empno||e.ename 编号和名字 FROM emp e;--字符串拼接SELECT CONCAT(e.empno,e.ename)FROM emp e;--字符串拼接
--筛选查询SELECT*FROM emp e WHERE sal >2000;--条件查询SELECT*FROM emp e WHERE sal <2000;--比较查询【>,>=,<,<=,!,<>】SELECT*FROM emp e WHERE sal =ANY(800,1600);--特殊比较查询ANY,任意一个满足SELECT*FROM emp e WHERE sal <>ALL(800,1600);--特殊比较查询ALL,所有满足SELECT*FROM emp e WHERE ename LIKE'B%';--关键字筛选LIKE(通配符%和_)SELECT*FROM emp e WHERE ename LIKE'B\%'ESCAPE '\';--关键字筛选LIKE(转义通配符)SELECT*FROM emp e WHERE sal IN(800,1600);--关键字筛选INSELECT*FROM emp e WHERE sal NOTIN(800,1600);--关键字筛选NOT INSELECT*FROM emp e WHERE sal BETWEEN800AND1600;--关键字筛选Between andSELECT*FROM emp e WHERE sal NOTBETWEEN800AND1600;--关键字筛选not between andSELECT
再复杂的SQL语句也不过是简单语句的堆砌而已,因此请反复练习下面的“砖块”并不断尝试组装复杂的SQL语句,多来几遍,SQL大神就是你!!!--简单查询SELECT * FROM dept;--基本查询SELECT * FROM dept d;--表的别名SELECT ROWID,deptno,dname FROM dept;--查询指定列SELECT deptno*100 FROM emp;--带有表达式的查询SELECT e.empno 员工编号,e.ename 员工名字 FROM emp e