Revision as of 07:42, 23 December 2020 edit Monkbot (talk \| contribs) Bots 3,695,952 edits m Task 18 (cosmetic): eval 6 templates: del empty params (3×); hyphenate params (3×); Tag: AWB ← Previous edit		Revision as of 09:03, 5 January 2021 edit undo Mx. Granger (talk \| contribs) Extended confirmed users, Pending changes reviewers, Rollbackers 71,081 edits removing undefined reference Next edit →
Line 130: === Inline view === An Inline view is the use of referencing an SQL subquery in a FROM clause. Essentially, the inline view is a subquery that can be selected from or joined to. Inline View functionality allows the user to reference the subquery as a table. The inline view also is referred to as a ''derived table'' or a ''subselect''. Inline view functionality was introduced in Oracle 9i.~~<ref name="Inline View/Derived Table" />~~ In the following example, the SQL statement involves a join from the initial Books table to the Inline view "Sales". This inline view captures associated book sales information using the ISBN to join to the Books table. As a result, the inline view provides the result set with additional columns (the number of items sold and the company that sold the books):

Select (SQL): Difference between revisions