Advertisement
Guest User

Untitled

a guest
Sep 25th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. SELECT TOP 5 with ties DefaultAccountNo, DefaultTermsID, COUNT (*) as
  2. VendorsQty
  3. FROM Vendors
  4. GROUP BY DefaultAccountNo, DefaultTermsID
  5. Having count(*) >= 5
  6. ORDER BY DefaultAccountNo DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement