Igor Tandetnik wrote:
Sergey M. Brytsko <[EMAIL PROTECTED]>
wrote:
But what about the following values:
1 1 2 2 100 100 100 100 100 100 100 100 100 100 100 111 111
If you susptect your data is likely to look like this, you may want to
rewrite your query as
SELECT BBB FROM XXX WHERE BBB < 100
union all
SELECT BBB FROM XXX WHERE BBB > 100;
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
Wouldn't this work as well?:
SELECT BBB FROM XXX
except
SELECT BBB FROM XXX WHERE BBB = 100;
Gerry
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
