Use of DISTINCT in SELECT close

[François Van Lerberghe]

Hello Stan,

You must decide what you do for the b column when there is duplicates on column a : you take the first, the last, …

If you decide to take the first value, your sql query could be this one : SELECT a, FIRST(b) FROM c GROUP BY a

François Van Lerberghe
Thier Monty, 15 A
4570 Marchin (Belgium)
+32 (0) 85 25 08 25

Le 30 nov. 2015 à 13:17, Stanley Roche Busk a écrit :

> 
> 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.