Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. SELECT customers, customer_code, Count(customer_code), date_of_purchase, Count(date_of_purchase), salesman, Count(salesman)
  2. FROM your_table
  3. GROUP BY customers, customer_code, date_of_purchase, salesman
  4. 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