Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. articles. downloads. faq. members. files. rss.
 From: Christian Tabligan
  Where is Christian Tabligan?
 Bacolod City, Neg. Occ.
 Philippines
 Christian Tabligan
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
Subject: RE: SQL MAX COUNT GROUP...
Thread ID: 180561 Message ID: 180606 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Friday, June 27, 2008 9:09:06 PM         
   



> >
> > I forgot somethin'
> >
> >
select "Code1" as Code_Group, code1 as Code, count(code1) as high_count from mytable group by code1  ;
> > union all;
> > select "Code2" as Code_Group, code2 as Code , count(code2) as high_count from mytable group by code2 into cursor cur_Temp
> > select top 2 * from cur_Temp order by high_count desc 

> >
> > CriZ (,")
> >
> > "Everyone is entitled to their own opinion, but not their own facts."

What? :-U

CriZ (,")

"Everyone is entitled to their own opinion, but not their own facts."

ENTIRE THREAD

SQL MAX COUNT GROUP... Posted by James Doherty @ 6/27/2008 6:41:01 PM
RE: SQL MAX COUNT GROUP... Posted by tushar @ 6/27/2008 6:59:05 PM
RE: SQL MAX COUNT GROUP... Posted by Borislav Borissov @ 6/27/2008 7:08:24 PM
RE: SQL MAX COUNT GROUP... Posted by Anders Altberg @ 6/27/2008 7:50:07 PM
RE: SQL MAX COUNT GROUP... Posted by Borislav Borissov @ 6/27/2008 7:51:28 PM
RE: SQL MAX COUNT GROUP... Posted by Anders Altberg @ 6/27/2008 7:58:18 PM
RE: SQL MAX COUNT GROUP... Posted by Borislav Borissov @ 6/27/2008 8:03:03 PM
RE: SQL MAX COUNT GROUP... Posted by Christian Tabligan @ 6/27/2008 8:08:05 PM
RE: SQL MAX COUNT GROUP... Posted by Borislav Borissov @ 6/27/2008 8:15:34 PM
RE: SQL MAX COUNT GROUP... Posted by Christian Tabligan @ 6/27/2008 8:53:02 PM
RE: SQL MAX COUNT GROUP... Posted by Borislav Borissov @ 6/27/2008 8:59:35 PM
RE: SQL MAX COUNT GROUP... Posted by Christian Tabligan @ 6/27/2008 9:03:18 PM
RE: SQL MAX COUNT GROUP... Posted by Anders Altberg @ 6/27/2008 9:08:36 PM
RE: SQL MAX COUNT GROUP... Posted by Christian Tabligan @ 6/27/2008 9:24:03 PM
RE: SQL MAX COUNT GROUP... Posted by Borislav Borissov @ 6/27/2008 9:32:25 PM
RE: SQL MAX COUNT GROUP... Posted by Christian Tabligan @ 6/27/2008 10:05:32 PM
RE: SQL MAX COUNT GROUP... Posted by Anders Altberg @ 6/27/2008 9:36:49 PM
RE: SQL MAX COUNT GROUP... Posted by Christian Tabligan @ 6/27/2008 9:46:05 PM
RE: SQL MAX COUNT GROUP... Posted by Anders Altberg @ 6/27/2008 9:05:38 PM
RE: SQL MAX COUNT GROUP... Posted by Christian Tabligan @ 6/27/2008 9:09:06 PM
RE: SQL MAX COUNT GROUP... Posted by Anders Altberg @ 6/27/2008 9:01:34 PM