Number of unique records in one (sql) command? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Number of unique records in one (sql) command?

Message

De

28/06/2007 15:36:45

Rich Pupko
Retired
Henderson, Nevada, États-Unis

À

28/06/2007 14:19:28

Zakaria Al Azhar
Actuaris.Net
Tétouan, Morocco

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Number of unique records in one (sql) command?

Divers

Thread ID:

01236514

Message ID:

01236543

Vues:

23

This message has been marked as the solution to the initial question of the thread.

>Hi all,
>
>Is there a (sql) command that can calculate the number of unique records of a field into a table with just one command in VFP 5?
>
>Thanks beforehand.

How about

SELECT COUNT (DISTINCT yourfield) FROM yourTable INTO ARRAY aTemp

Click here to load this message in the networking platform