how to count all the record of a particular field in db

Mar 14 2019 12:58 AM

i have a table where there is a column name budgetedcost it contains cost of 3 years

for eg

budgetedcost

2000

360

100

i want the total of all this for above colum my total should be 2460

i want to calculate the total cost of three years in gridview how to write an sql query for that

Answers (7)