{CodeRoyale}
All challenges
Multiple ChoiceIntermediate 30s

LEFT JOIN

Choose the best answer for: LEFT JOIN behavior
Options
  1. 1LEFT JOIN returns all rows from left table plus matching right rows
  2. 2LEFT JOIN is the same as INNER and drops the unmatched rows
  3. 3LEFT JOIN deletes the left rows that have no matching pair
  4. 4LEFT JOIN only returns the rows matching on both tables here
backendintermediate

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.

Play this in a 3-minute battle