Querying data stores with SQL
:
Supported SQL and Extensions
:
Select
:
From Clause
:
Subquery in a From Clause
Try Now
Subquery in a From Clause
Subqueries can be used in the
From
clause in place of table references (
table_name
). For example:
SELECT * FROM (SELECT * FROM emp WHERE sal > 10000) new_emp, dept WHERE new_emp.deptno = dept.deptno
