Database Analyst Question:
Download Job Interview Questions and Answers PDF
Explain me what is self JOIN?
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 Question | Next Question |
Do you know what is a subquery? | Tell me what are the differences between primary and foreign keys? |