Q. What is a Self Join?
Solution:
A Self Join is a regular join, but the table is joined with itself. This is useful for querying hierarchical data or comparing rows within the same table (e.g., finding employees who have the same manager).
Related Questions
Q. Which query would count the number of distinct cities in the ‘Customers’ table?
View SolutionQ. What is the purpose of the HAVING clause?
View SolutionQ. How can you remove a table from the database?
View Solution
Get Question Bank
Strengthen Your Practice with our comprehensive question bank.
