Select-sql statement - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Select-sql statement

Message

01/02/2002 15:21:15

01/02/2002 15:20:14

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Divers

Thread ID:

00614246

Message ID:

00614248

Vues:

>Hi All,
> Is there a way to craft a select statement to list what is in a field and how many times what is in the field repeat?
>Thanks,

SELECT field1, COUNT(*) FROM mytable GROUP BY 1

--sb--