Counting by codes in a table

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Counting by codes in a table

Message

From

19/01/2004 14:14:11

19/01/2004 14:01:43

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Miscellaneous

Thread ID:

00868238

Message ID:

00868249

Views:

Hi Harry, try something similar to this.

SELECT customer, COUNT(orders) ;
 FROM table ;
 GROUP BY customer ;
 INTO CURSOR results