Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Count(distinct)
Message
 
À
21/11/2003 09:57:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00852294
Message ID:
00852304
Vues:
8
>>Hi all, the other day I needed to do a SQL SELECT and I used count(distinct "Field_name") and that worked they way I wanted but realized that's a feature of the VFP SQL syntax that is undocumented (at least on the help files). Now my question is: are there any other undocumented feature/function/command like that? Where can I find information on them?
>>
>>Thanks in advance!
>
>Enmanuel
>
>COUNT and DISTINCT are documented under SELECT - SQL, although they are standard SQL commands, they are still included in the VFP documentation.
>
>Kev

Hi Kevin, yes I know. What I meant is for example the help file says you can use "SELECT DISTINCT" but not that you can include the distinct clause inside any of the other functions used in the SELECT statement, like the COUNT() function in my case.

Enmanuel
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform