# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 2052611718

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Create an inline view.

Definition

Creation consists of a SELECT statement within a FROM clause of another SELECT statement, such as in this example:
SELECT a.<column 1>, a.<column 2>, b.<column 1>
FROM <table 1>a, (SELECT <column 1 or expression>, <column n or expression> FROM <table 2> GROUP BY column 1) b
WHERE a.
<column 3> =b.<column 1>