Re: group by problem

In article <MPG.1919b80bb3de5d0d989684_at_H02374>, marc.eggenberger_at_itc.alstom.com says...

[...]

I solved my problem .. did a subselect:

select h.NODE, h.HOSTNAME, l.ORT

    from ams.hardware h, ams.LOCATION l
    where h.LOC_RECNO = l.STANDORT_NR (+)     AND node in
    (

        select node as anzahl from ams.hardware group by node having count(node) > 1

    )  

-- 
mfg
Marc Eggenberger