--Using a subquery in the WHERE clause to filter data: ...
select ename, sal, deptno from EMP where sal > 2000 and deptno = (select deptno from EMP where ename = "james"); select * from EMP where sal > (select sal from EMP ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results