Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>If a rep works on 4 projects, they're still only 1 rep.
Right, Either will give you that.
>So should distinct be used if it's slower?
I don't have any performance data on the two methods. My suggestion is try them, and see which one is faster.
(Honestly, I just thought of the two-step version first, and I in general avoid using DISTINCT unless using GROUP BY makes things too unclear, or difficult, performance per se was not why I suggested the two-step first)
>per hackers guide =?=
Just giving credit where credit is due. I looked at the Hacker's Guide to VFP 6.0 to refresh my memory on the DISTINCT clause within fields, and so the example was theirs. AFAIK its fully supported VFP SQL Syntax.
HTH,
Bill
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement