Use of DISTINCT in SELECT close

[Stanley Roche Busk]

Ok, so how can I do that?, GROUP BY? I have tried several combinations unsuccessfully so far.

What I want is: SELECT a, b FROM c

where there is no c duplicates but b column is accesible.

Stan

> On Nov 28, 2015, at 11:15 AM, Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com> wrote:
> 
> 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]
> 
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta