Re: Find non-unique "key" values via SQL

Dan
Yeh - I know what you mean. This one took AGES for it to sink in with me.



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
midrange-l-bounces@xxxxxxxxxxxx wrote on 01/09/2007 03:14:50 PM:

On 1/9/07, Alan Shore <AlanShore@xxxxxxxx> wrote:

select daCusN, count(*) from OPLOGDATA
    HAVING count(*) > 1
    group by daCusN

Boy, SQL's finicky with English usage, ain't it?  ;-)

Thanks for the tip, Alan.  Not sure why, but I had to switch the HAVING

line

with the GROUP BY line to get it to work:

    select daCusN, count(*) from OPLOGDATA
        group by daCusN
        HAVING count(*) > 1

Thanks,
Dan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.