数据库的学习

1.数据库学习（查询语句的深化）
  运算查询，
  子查询，
  连表语句 inner join on两边都有的显示,left,right左右分别有的显示
  分页查询 limit *，*从哪条开始之后几条
 
























SELECT * from emp WHERE sal > (SELECT AVG(sal) from emp) ORDER BY sal




SELECT * from (SELECT * from emp) e
SELECT empno from emp where empno = 7369 or empno = 7499 or empno = 7521
SELECT * from emp WHERE empno IN(SELECT empno from emp where empno = 7369 or empno = 7499 or empno = 7521)


SELECT e.*,d.dname FROM emp e,dept d WHERE e.deptno=d.deptno
SELECT e.*,d.loc FROM emp e,dept d WHERE e.deptno=d.deptno


SELECT e.*,d.deptno,d.loc from emp e INNER JOIN dept d ON e.deptno=d.deptno




SELECT * FROM emp LIMIT 5,3








2.JAVA对数据库进行增删改查