Which type of JOIN returns only the rows where there is a match in both tables?
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL OUTER JOIN
An INNER JOIN returns only the rows where there is a match in both tables. It combines records from two tables based on a common column and includes only the rows with matching values in both tables. Rows with no matching values are excluded from the result set.
Loading...
Related Quiz
- Which of the following are common uses of Regular Expressions in PHP?
- Which of the following predefined PHP functions can be used to sort an array in descending order?
- What is a common use case for the $GLOBALS superglobal in PHP?
- You have a PHP script and you need to call a user-defined function using a string variable. How would you do this?
- A common use case for Regular Expressions in PHP is to ______.