Select-sql statement - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Select-sql statement

Message

From

01/02/2002 15:21:15

01/02/2002 15:20:14

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Miscellaneous

Thread ID:

00614246

Message ID:

00614248

Views:

>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--