PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → query which displays every item one's
query which displays every item one's
Débuté par Frans, 27 mar. 2006 11:30 - 2 réponses
#1
Posté le 27 mars 2006 - 11:30
Hello to you all,
How can I make a query which display every unique of a file only ones?
So for a place not 10 times Paris. Only one time paris.
I think this can't be difficult but I didn't find it in the query-maker.
Regards and thanks in advance,
Frans
#2
Posté le 27 mars 2006 - 12:04
Hi Frans
In SQL look at Distinct and DistinctRow
Hello to you all,
How can I make a query which display every unique of a file only ones?
So for a place not 10 times Paris. Only one time paris.
I think this can't be difficult but I didn't find it in the query-maker.
Regards and thanks in advance,
Frans



http://www.objeKtive.com
#3
Posté le 27 mars 2006 - 12:28
>Hello to you all,
Sometimes I am a bit blind.
I completely overlooked the button 'Delete duplicates'.
Thank for the reaction.
Regards Frans
→ Revenir à WINDEV 2024