Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count Function
Message
 
To
24/09/2002 10:25:20
Ger Connolly
Icm Unicomp
Dublin, Ireland
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Count Function
Miscellaneous
Thread ID:
00703773
Message ID:
00703777
Views:
12
Hi Ger

Try:

Select code,cnt(*) from table group by code [having cnt(*)>1]

The last section is used to find duplicate account codes for example


K
Kevin Delaney
Financial Systems Manager
CPL Solutions Ltd

83 Merrion Square, Dublin 2, Ireland.
e: kevin.delaney@cpl.ie w: www.cpl.ie
p: +353 1 482-5368
Previous
Reply
Map
View

Click here to load this message in the networking platform