| Author: Reach2Shaik 22 Nov 2008 | Member Level: Gold | Rating:  Points: 1 |
select count(Amount) from tablename where name=A1;
use this query
Don't forget to rate this answer, if it is helpful...
Regards Shaik
|
| Author: Deepika Haridas 22 Nov 2008 | Member Level: Diamond | Rating: Points: 3 |
select count(Amount) from tablename where name = 'A1';
select count(Amount) from tablename where name = 'B1';
select count(Amount) from tablename where name = 'C1';
Regards,
Deepika
Thanks & Regards,
Deepika
Editor
If U want to shine like a SUN..First U have to burn like the SUN!!
Need a Guide? Join my mentor program..
|
| Author: shailendra rampal 22 Nov 2008 | Member Level: Bronze | Rating: Points: 1 |
select sno,name,amount as total amount from <table name> group by name
|
| Author: Sriman N Vangala 23 Nov 2008 | Member Level: Diamond | Rating: Points: 4 |
The simple solution for this is to make use of the select statement displaying the sum of the amount by grouping the column 'Name'
select Name ,sum(Amount) Amt from table
group by Name
which display the output like this:
Name Amt
A1 30
B1 20
C1 10
|