Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE usp_GetHoldersWithBalanceHigherThan(@amount MONEY)
- AS
- BEGIN
- SELECT FirstName, LastName FROM AccountHolders AS ac
- LEFT JOIN Accounts AS a ON a.AccountHolderId = ac.Id
- GROUP BY FirstName, LastName
- HAVING SUM(Balance) > @amount
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement