Name BankAccountNumber Amount Test1 12321 2000 Test1 1222 2000 Test2 2323232 3000 Test2 12312323 1000
Name BankAccountNumber Amount Test1 12321 4000 Test2 2323232 4000
select name, FIRST(BankAccountNumber), SUM(Amount) from Customers group by name, Amount
SELECT Name, BankAccountNumbe, SUM(Amount) AS AMOUNT from Customers WHERE BankAccountNumbe in(12321,2323232) GROUP BY Name,BankAccountNumbe
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)