Re: I know this has been asked before, but....
| From: | Ron Brogden | Date: | Wed, 11 Apr 2001 23:18:22 +0000 |
| Subject: | Re: I know this has been asked before, but.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8506@lists.php.net to get a copy of this message | ||
At 04:08 PM 4/11/2001 -0700, Ron Brogden wrote:
SELECT column_name, count(*) AS doubles FROM some_table HAVING doubles > 1 GROUP BY colnameAck, that GROUP BY should be "column_name" (was trying to make it more obvious and missed the last reference). Cheers -----------------------------------------------------------------------------
Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free: 1 800 331-3055 Victoria, B.C. Fax: 250 383-6698 V8W 2L1 E-Mail: support@islandnet.com Canada WWW: http://www.islandnet.com/-----------------------------------------------------------------------------