Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001041

Re: [PHP-DB] I know this has been asked before, but.... From: Ron Brogden (rb <email protected>)
Date: 04/11/01

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 colname

Ack, 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 <email protected>
Canada WWW: http://www.islandnet.com/
----------------------------------------------------------------------------- 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>