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: 249238 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, December 30, 2009 8:59:54 PM         
   


> Dear Exprtt,
> Please correct the select statement below
>
>
>
> select * from grade;
> where count(code1) >=2;
> group by code1;
> order by code1;
>
>
> code1 level
> ------------
> AA 22
> AA 33
>
> BB 11
>
> CC 33
> CC 44
> CC 66
>
>
>
> EXPECTED OUTPUT
> ---------------
>
> code1 level
> -------------
> AA 22
> AA 33
>
> CC 33
> CC 44
> CC 66
>
> Pls assist me with the select statement
>
>
> Thanks

Hi Derek
Been on holiday?
Have you checked out the replies to your thread Message ID: 249029

-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