摘要: 1、单行子查询 select ename,deptno,sal from emp where deptno=(select deptno from dept where loc='NEW YORK'); 2、多行子查询 SELECT ename,job,sal FROM EMP WHERE dept 阅读全文
posted @ 2016-09-21 17:33 每天来逛逛 阅读(4840) 评论(13) 推荐(0) 编辑