Query select non-repited records

[Deus_m1k3]

Hi:!

I'm tryin' to select from a table all the records but only the ones that aren't repited...

READ YA
Deus_m1k3

[Deus_m1k3]

Oopps... 4got 2 tell ya that I need to select 3 columns that have a name and 2 last-names but I need that the query select the non repeated rows...

read ya
Deus_m1k3

[Deus_m1k3]

JA!... sorry I 1st posted the message & then check a manual... LOL

SELECT DISTINCT first,second,third FROM table ORDER BY first;

read ya
Deus_m1k3