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: [EMAIL PROTECTED]
Canada WWW: http://www.islandnet.com/
-----------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]