|
|
Posted by jim_geissman on 06/19/06 18:39
This should work. WHERE limits which cases go into the tally.
HAVING limits which results are output after the tally is completed.
In this case, it limits the output to those object-keyseq combinations
where the count is greater than one, which I believe is what you're
after.
> Some helpful person (thanks m cadot) in the Oracle group gave me some
> guidance and made an initial suggestion which I show here, and a more advanced
> solution I'm not showing because I don't understand it, and it might be oracle
> specific.
>
> select object, keyseq, count(keyseq)
> from metatable
> where keyseq is not null
> group by object, keyseq
> having count(*) > 1 ---<----- just this line to add
> order by count(keyseq)
Navigation:
[Reply to this message]
|