List:General Discussion« Previous MessageNext Message »
From:Inc. Information Systems Menard Date:August 16 2002 5:44pm
Subject:RE: Count and group by problems
View as plain text  
Me again

I found a work around to my problem:
select country, count(distinct client_name, client_address, etc..) clients
from addresses group by country

But I still don't understand why the below would not work. I downloaded the
3.# version of the OBDC but that didn't seem to help.

Help.....

Thanks
Jake

-----Original Message-----
From: Menard, Inc. Information Systems [mailto:isdept@stripped]
Sent: Wednesday, August 14, 2002 5:26 PM
To: David Kramer; frsgti@stripped; mysql@stripped
Subject: RE: Count and group by problems


For an example let's say that I have clients in multiple countries and I
want a list of the number of clients per country. In order to do this I
would think a statment like:

select country, count(*) clients from addresses group by country

would work just fine. I have have been working in VB on NT with odbc client
2.50.39.00.
I have tried all of the cursor combinations that I could think of, but I
still at a loss. Could there be a problem with the version of the client???

Thanks again

Jake

-----Original Message-----
From: David Kramer [mailto:DKramer@stripped]
Sent: Friday, August 09, 2002 5:59 PM
To: 'Menard, Inc. Information Systems'; mysql@stripped
Subject: RE: Count and group by problems


Im not sure I understand what it is that you are trying to do here???  Im
assuming your using PERL/SomeScriptingLang on something on NT to connect to
mysql using the ADO object...  Within your Count(*) Group by are you trying
to return a result set that contains a duplicate row count, i.e.
Column=Booger, Count(*)=2???  If you provide a little more info I might be
able to help here, if what I said above is true then maybe do something like
this

select foo, count(*) CNT from Table group by foo having CNT > 1;

Not sure on the syntax though, but something along those lines...

DK

-----Original Message-----
From: Menard, Inc. Information Systems [mailto:isdept@stripped]
Sent: Friday, August 09, 2002 3:10 PM
To: mysql@stripped
Subject: Count and group by problems


Evening

I think I'm losing my mind. I have a very simple query that works fine in
MySQLFront but will not work when I connect using ADO:

select booger, count(*) from nose group by booger

If I try the above query with one record It works fine. Once I try it with
more records, nothing returns.

If I try:
select booger from nose group by booger
It returns results with one or more records.

Thanks for all of your help!

Jake


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread116768@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-dkramer=reflect.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread116773@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-isdept=menard-inc.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread117135@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-isdept=menard-inc.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Thread
Count and group by problemsInc. Information Systems Menard10 Aug
  • Re: Count and group by problemsFrancisco12 Aug
RE: Count and group by problemsDavid Kramer10 Aug
  • RE: Count and group by problemsInc. Information Systems Menard15 Aug
    • RE: Count and group by problemsInc. Information Systems Menard16 Aug
      • Re: RE: Count and group by problemsEgor Egorov17 Aug