1、单行子查询selectename,deptno,salfromempwheredeptno=(selectdeptnofromdeptwhereloc='NEWYORK');2、多行子查询SELECTename,job,salFROMEMPWHEREdeptnoin(SELECTdeptnoFROMdeptWHEREdnameLIKE'A%');3、多列子查询SELECTdeptno,ename,job,salFROMEMPWHERE(deptno,sal)IN(SELECTdeptno...
查看全文