By default, duplicate rows are not returned. To permit duplicate rows to be returned, specify the ALL option.