Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: RE: problem with COUNT()
Thread ID: 249235 Message ID: 249269 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, December 31, 2009 10:18:22 AM         
   


> >
> > Hi Derek
> > Been on holiday?
> > Have you checked out the replies to your thread Message ID: 249029
> >
> > -Anders
>
> Hi Anders,
>
> The solution you gave didn't work.
>
> What it gave was the distinct grades.
>
> Thanks


I misunderstood the requirement.

SELECT * FROM Grade WHERE code1 IN (SELECT grade FROM Grade ;
 GROUP BY grade HAVING COUNT(*) >=2)

Will that run in VP6?

-Anders

ENTIRE THREAD

problem with COUNT() Posted by DEREK DODOO @ 12/30/2009 8:03:38 PM
RE: problem with COUNT() Posted by Anders Altberg @ 12/30/2009 8:55:28 PM
RE: problem with COUNT() Posted by Anders Altberg @ 12/30/2009 8:59:54 PM
RE: problem with COUNT() Posted by DEREK DODOO @ 12/31/2009 6:57:05 AM
RE: problem with COUNT() Posted by Anders Altberg @ 12/31/2009 10:18:22 AM
RE: problem with COUNT() Posted by tushar @ 12/31/2009 10:20:23 AM
RE: problem with COUNT() Posted by Anders Altberg @ 12/31/2009 10:23:00 AM