a guest Jan 21st, 2020 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select min(dbkey) from ix_spc_performance perf ,
  2. (select dbparentplanogramkey, DBParentProductKey
  3. from ix_spc_performance
  4. group by dbparentplanogramkey, DBParentProductKey
  5. having count(*) >1
  6. ) a
  7. where a.dbparentplanogramkey = perf.dbparentplanogramkey
  8. and a.DBParentProductKey = perf.DBParentProductKey
  9. group by perf.dbparentplanogramkey, perf.DBParentProductKey;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand