Collections:
Use Subqueries in the FROM Clause in Oracle
How To Use Subqueries in the FROM Clause in Oracle?
✍: FYIcenter.com
If you have a query returning many rows of data, and you want to perform another query on those rows, you can put the first query as a subquery in the FROM clause of the second query. The following statement shows you how to use a subquery as base table for the main query:
SQL> SELECT * FROM ( 2 SELECT first_name, last_name, department_name 3 FROM employees e, departments d 4 WHERE e.department_id = d.department_id 5 ) WHERE department_name LIKE 'S%' ORDER BY last_name; FIRST_NAME LAST_NAME DEPARTMENT_NAME ----------------- ---------------------- --------------- Ellen Abel Sales Sundar Ande Sales Mozhe Atkinson Shipping Amit Banda Sales Elizabeth Bates Sales Sarah Bell Shipping ......
⇒ Counting Groups Returned with the GROUP BY Clause in Oracle
⇐ Use Subqueries with the EXISTS Operator in Oracle
2019-09-27, 1587🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...