Use of DISTINCT in SELECT close

Sat Nov 28 04:15:03 CST 2015

On 11/27/15, 2:24 PM, "Stan Busk" <maxprog at mac.com> wrote:

> Hi,

Why if I have a DB with 25k records and I do a SELECT DISTINCT A, B
> (where B is always different) I get a result of 25k? Isn¹t the DISTINCT option
> for the first column A?

No

It works on all

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]