What is the difference between INNER JOIN and LEFT JOIN in SQL?
- Only returns matched rows from both tables
- Returns all rows from both tables
- Returns all rows from the left table
- Returns all rows from the right table
INNER JOIN and LEFT JOIN are both SQL join clauses used to combine rows from two or more tables based on a related column between them. INNER JOIN returns only the matched rows from both tables, while LEFT JOIN returns all rows from the left table and the matched rows from the right table.
Loading...
Related Quiz
- The ________ layer of the OSI Model is responsible for segmenting data and ensuring its reliable delivery.
- You're working on a project where SEO is critical. How would you implement server-side rendering (SSR) with React or Angular to ensure better search engine visibility?
- How do you comment out a single line of code in JavaScript?
- Explain the concept of polymorphism in OOP with an example.
- The ___________ algorithm is used to find the shortest paths between nodes in a weighted graph.