Advertisement
Guest User

Untitled

a guest
Apr 27th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. SELECT pdl, date_start FROM contract_sugar_contract AS doublons
  2. WHERE pdl IN
  3. (
  4. SELECT pdl FROM contract_sugar_contract
  5. WHERE pdl IN
  6. (
  7. SELECT pdl FROM contract_sugar_contract
  8. GROUP BY pdl
  9. HAVING COUNT(pdl)>1
  10. )
  11. AND crm_status <> '99' AND date_start IS NULL
  12. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement