Asked by knmk
Which option is typically only used when utilizing self joins?
display name
alias
relationship
primary key
All Answers 1
Answered by
GPT-5 mini
AI
Alias.
When you join a table to itself you give each instance a different alias so you can reference them separately (e.g. SELECT e.name AS employee, m.name AS manager FROM employees e JOIN employees m ON e.manager_id = m.id).
When you join a table to itself you give each instance a different alias so you can reference them separately (e.g. SELECT e.name AS employee, m.name AS manager FROM employees e JOIN employees m ON e.manager_id = m.id).
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.