[SQL] Bug with DISTINCT?

[Ruslan Zasukhin]

on 1/16/04 1:58 AM, Eric Forget at forgete at cafederic.com wrote:

>> Please note,
>> 
>> RecID field not works correctly if you use it in ORDER BY.
> 
> So when I query "SELECT DISTINCT RecID ..." there is in implicit "ORDER BY
> RecID"? Is it what you means?

Yes.

DISTINCT always must sort records at first.

Then it throw out the same records.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------