Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: problem with COUNT()
Thread ID: 249235 Message ID: 249235 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, December 30, 2009 8:03:38 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

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