HomeInterview QuestionsWhat does an inner join return?

What does an inner join return?

🟢 Easy Conceptual Fresher level
1Times asked
Apr 2026Last seen
Apr 2026First seen

💡 Model Answer

An inner join returns only the rows where the join condition is true in both tables. In other words, it gives you the intersection of the two tables based on the specified key. Rows that do not have a match in the other table are excluded.

This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.

🎤 Get questions like this answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.

Get Assisting AI — Starts at ₹500