Working with Subqueries

Oracle 12c
  • 11 Videos | 39m 54s
  • Earns a Badge
Likes 51 Likes 51
It's not uncommon to need more than one query to get to the data results you require. Learn about using subqueries to solve problems in Oracle Database 12c.

WHAT YOU WILL LEARN

  • use a subquery to solve a problem in a SQL statement
    describe the rules, guidelines, and types of subqueries used in a SQL statement
    use a single-row subquery to return one row in a SQL statement
    display data from a main query using a group function in a subquery to return a single row in a SQL statement
    use a subquery in the HAVING clause of a SQL statement
    identify common errors that occur when an incorrect number of rows is returned by a single-row subquery in a SQL statement
  • describe multiple-row subqueries in a SQL statement
    use the IN, ANY, and ALL operators in multiple-row subqueries in a SQL statement
    use a multiple-column subquery to return more than one column to the outer query in a SQL statement
    describe NULL values in a subquery and use the NOT IN operator in a SQL statement
    combine two queries by making use of a subquery  in a SQL statement

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 152 Likes 152  
Likes 223 Likes 223  
Likes 25 Likes 25