Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT customers, customer_code, Count(customer_code), date_of_purchase, Count(date_of_purchase), salesman, Count(salesman)
- FROM your_table
- GROUP BY customers, customer_code, date_of_purchase, salesman
- HAVING (Count(customer_code) > 1) AND (Count(date_of_purchase)) > 1 AND (Count(salesman) >1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement