Sql Rank for records contain multiple combinations
I'm not familiar DB2, but if it allows using count as analytic function you can do 

select * 
from 
    (select b.Store,b.order, 
            rownumber() over (partition by b.store order by b.order) AS RNK ,
            count(*) over (partition by b.store) cnt
     from Library.Table1 b
    ) tmp 
where tmp.cnt &gt; 1 
order by tmp.Store


If not, the query below should give you the same result (maybe not the best solution from performance perspective ) :

select tmp.* 
from 
    (select b.Store,b.order, 
            rownumber() over (partition by b.store order by b.order) AS RNK 

     from Library.Table1 b
    ) tmp 
    INNER JOIN 
    (
        SELECT store 
        FROM Library.Table1  
        GROUP BY store
        HAVING (COUNT(*) &gt;1)
    )tmp2 ON (tmp2.store = tmp.store)

order by tmp.Store