Copyright

SQL: Self-Joins

Instructions:

Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

Examine the following code: What would be the correct way to complete the FROM statement?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. A self-join can be used for what purpose?

2. Examine the following code. What is missing from the self-join statement?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

Test your awareness of SQL self-joins. You'll need to answer questions on topics like completing a FROM statement and what self-joins are used for.

Quiz & Worksheet Goals

You'll also be quizzed on the following:

  • Something that is missing from a given self-join statement
  • The part of a self-join statement that leads to one record per criteria being returned
  • The comparison of data in a self-join query

Skills Practiced

  • Making connections - use understanding of the concept of a self-join query to recognize how it compares data
  • Information recall - access the knowledge you've gained regarding FROM statements
  • Interpreting information - verify that you can read information regarding the purpose of a self-join and interpret it correctly

Additional Learning

This subject can be explored further via the lesson entitled SQL: Self-Joins, which you can read or view at any time. It will help you to understand the following study points:

  • What an alias is, in this context
  • Examples of the application for a self-join
  • Running count in a self-join comparison
Support