In the context of this code challenge, if there are less than 20 distinct names that start with ‘S’, what happens if our
LIMIT value is greater than this?
In SQL, the
LIMIT statement acts as an upper bound for the number of rows that will be retrieved from the result set.
As a result, if your
LIMIT value was set to 20, but there are less than 20 rows that match the query, then it will only return what is there, even if there were no matches, because
LIMIT only acts as an upper bound, not a strict requirement for the amount of rows that must be returned.