|
i am using MS SQL for my db.
the data type of the field(noofdays) is decimal.
below are the value of the field (noofdays)
1.1
.5
.6
1.1
i want to add these numbers, what syntax i am going to use?
thanks
|
|
|
Not sure i understood your query well... but i think you wanted to get the sum of column NoofDays. you may use
Select Sum(noofdays) as TotalDays from tableName.
- hope this answer your query well.
|
|
|
|
|
|
|
|
|
|