sql query 1

[ishikha]

hi friends,

how i can write the sql query for this

my table "document" is like this

name description total
a abc 5
b df 2
c jb 4
a dfg 12

now i want that it gives me the ans

name total
a 17

that means it shows the total of particular name along with name


regards
ishikha

 

[ishikha]

hi,

i want the output as:

name total
a 17
b 2
c 4


ishikha

 

[thesleepylizard]

Hi, this is fairly easy. Try running this query:

SELECT Name, Sum(total) AS My_Total FROM MyTable GROUP BY Name;