Silviya7

10. People with Balance Higher Than

Jun 8th, 2022 (edited)
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. CREATE PROCEDURE usp_GetHoldersWithBalanceHigherThan
  2.  @numbersal DECIMAL(9,2)
  3. AS
  4. BEGIN
  5.  
  6.  
  7. SELECT  ah.FirstName ,  ah.LastName
  8.  
  9. FROM AccountHolders ah INNER JOIN Accounts a
  10. ON ah.Id= a.AccountHolderId
  11. GROUP BY ah.FirstName,ah.LastName
  12. HAVING SUM(a.Balance)  >@numbersal
  13.  
  14.  
  15. END
Add Comment
Please, Sign In to add comment