[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] any SQL gurus?
- Subject: [ale] any SQL gurus?
- From: phasefx at magusaptus.com (Jason Etheridge)
- Date: Wed Jan 21 13:33:53 2004
- In-reply-to: <20040121161312.VYIR1944.imf25aec.mail.bellsouth.net@BLUGLO>
- References: <20040121161312.VYIR1944.imf25aec.mail.bellsouth.net@BLUGLO>
On Jan 21, 2004, at 11:13 AM, Matthew Brown wrote:
> Nahh.. No need for a sub-select on this one. Lemme ponder.
Thanks. :) J.M. Taylor knew what I was doing wrong with DISTINCT and
COUNT. I needed to treat DISTINCT as a function and pass it into COUNT
like so: SELECT COUNT(DISTINCT(title_key)) FROM COPY WHERE owner =
"Joe";
I appreciate everyone's help.
-- Jason