Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: problem with COUNT()
Thread ID: 249235 Message ID: 249270 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, December 31, 2009 10:20:23 AM         
   


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

The column name is code1 :-)

Regards
Tushar

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