Consider the following query: Assuming col1 is non-NULLable, this will yield either true or false – or possibly NULL when table1 is empty; But now suppose I have: (and assume col2 is also non-NULLable for simplicity.) If there is a unique col2 value for the lowest col1 value, or the table is empty, then this works just like before. But