API tools faq
paste
Guest User

Untitled

a guest
Jan 24th, 2018
68
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
raw download clone embed print report
  1. BranchName CustID
  2. ========== ======
  3. Branch1 1111
  4. Branch1 1111
  5. Branch1 2222
  6. Branch2 2222
  7. Branch2 4444
  8. Branch3 1111
  9. Branch4 3333
  10.  
  11. BranchName DistCountofCust
  12. ========== ======
  13. Branch1 2
  14. Branch2 1
  15. Branch3 0
  16. Branch4 1
  17.  
  18. SELECT X.BranchName, COUNT(DISTINCT X.CustID) as DistCountofCust
  19.  
  20. FROM
  21.  
  22. (SELECT T.BranchName, T.CustID
  23.  
  24. FROM MyTable T) as X
  25.  
  26. GROUP BY X.BranchName
Add Comment
Please, Sign In to add comment
Public Pastes
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!