Phil Rhoades wrote:
> People,
>
> I want to select from a table ONLY unique records ie if a column has
> values:
>
> 1
> 2
> 3
> 3
> 4
> 5
>
> I want ONLY these records returned:
>
> 1
> 2
> 4
> 5
SELECT count(*) as cnt,a,b,c FORM yourtable
GROUP BY a,b,c
HAVING cnt=1
should do.
Regards
Tino
