Sometimes it IS meaningful to select rows where there is no equal value. Consider the emp and salgrade tables. The salgrade table shows the grade associated with a salary range.
