Database Analyst Question:

Download Job Interview Questions and Answers PDF

Explain me what is self JOIN?

Database Analyst Interview Question
Database Analyst Interview Question

Answer:

Self JOIN is a query that joins a table with itself. This is used to compare the values of a particular column with other values in the same column of the same table. Self JOIN uses aliases to name the original and duplicate tables.

Download Database Analyst Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know what is a subquery?Tell me what are the differences between primary and foreign keys?