Select nested Query

Select nested query without source code and Demonstration: source code source -- single-row subquery selectename, sal, deptnofromempwheredeptno (distinct) selectename, sal, deptnofromempwheredeptno (distinct) -- multiple lines

Select nested query without source code and Demonstration: source code source -- select ename, sal, deptno from emp where deptno = (select deptno from emp where ename = 'Scott ') select ename, sal, deptno from emp where deptno = (select deptno from emp where ename = 'Scott ') -- multiple rows

Select nested Query <无>

Source code and demo:Source code

-- Select ename, sal, deptno from emp where deptno = (select deptno from emp where ename = 'Scott ') select ename, sal, deptno from emp where deptno = (select deptno from emp where ename = 'Scott ') -- select ename, sal, deptno, job from emp where job in (select distinct job from emp where deptno = 10) select ename, sal, deptno, job from emp where sal> all (select sal from emp where deptno = 30) select ename, sal from emp where deptno = 30 select ename, sal, deptno, job from emp where sal> any (select sal from emp where deptno = 30) -- Multi-column subquery select ename, sal, deptno, job from emp where (deptno, job) = (select deptno, job from emp where ename = 'Smith ') update empset sal = 1500, comm = 30 where ename = 'clark' select ename, sal, comm from emp where ename = 'clark' select ename, sal, comm, deptno from emp where (sal, nvl (comm,-1) in (select sal, nvl (comm, -1) from emp where deptno = 30) select ename, sal, comm from emp where deptno = 30 select ename, sal, comm, deptno from emp where sal in (select sal from emp where deptno = 30) and nvl (comm,-1) in (select nvl (comm,-1) from emp where deptno = 30)