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
-
Introduction to HTML and CSS Coding: Getting Started with CSS
$15.00In this course you will learn how to add the "style" tag to the HTML code, add colors to elements with CSS, and use identifiers to select elements to style. -
Introduction to HTML and CSS Coding: Styling Text with CSS
$15.00In this course you will learn how to change the font-family of a section of text, change the font size of a section of text, use additional CSS text properties, including font-style, font-weight, line-height, and text-align, and use the CSS font style shorthand. -
Introduction to HTML and CSS Coding Part 2: Complex Selectors
$15.00In this course, you will learn how to use commonly used selectors, child selectors, attribute selectors, and pseudo-selectors. -
Microsoft Excel Online: Using Pivot-Tables
$0.00In this course you will learn how to insert PivotTables, work with PivotTable data, and sort and filter PivotTable data.
Reviews
There are no reviews yet.