Quiz on SQL SELF JOIN

What is a SELF JOIN in SQL?

Which SQL clause is used to define matching logic in a SELF JOIN?

Which scenario is best suited for a SELF JOIN?

What is required to avoid ambiguity in SELF JOINs?

What does this query do?

SELECT a.name, b.name
FROM employees a
JOIN employees b ON a.manager_id = b.id;

Can a table be joined more than once in a SELF JOIN?

In SELF JOINs, aliases help to

What will this query return?

sql
SELECT a.emp_id, b.emp_id
FROM employees a
JOIN employees b ON a.salary > b.salary;

What type of JOIN is a SELF JOIN technically?

What happens if you forget aliases in a SELF JOIN?

What does this SELF JOIN query do?

sql
SELECT a.name, b.name
FROM employees a
JOIN employees b ON a.department_id = b.department_id
AND a.id <> b.id;

Which is TRUE about SELF JOIN?

In what case will a SELF JOIN return an empty result?

How do you prevent self-matching in SELF JOINs?

Which of these use cases best fits SELF JOIN?