Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2020
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement