A subquery is a SELECT statement nested in a statement or in another subquery. Usually, they are used to return data that will be used in the main query as a condition to help narrow down the data that is being retrieved. This course teaches students what subqueries are, how to create a subquery, how to create subqueries with aggregate functions, about nested subqueries, and how to use the IN keyword with subqueries.
Related Products
-
Microsoft 365 Word: Online: Getting Started
$99.00In this course you will learn how to: Get started with Word Online, Manage documents, Work with text, Find and replace text, Change view options, and Get help in Word Online. -
Microsoft 365 PowerPoint Online: Working with SmartArt
$99.00In this course you will learn how to: Create, modify, and format SmartArt. -
Microsoft 365 OneNote: Online: Working with Notes, Part One
$99.00In this course you will learn how to: use formatting tools, and add images, tables, and other elements to a notebook. -
Microsoft 365 Word: Online: Inserting Objects
$99.00In this course you will learn how to: Add headers and footers to a document, Insert footnotes and endnotes, and Insert, modify, and format tables.
