Sql query

Accepted answer

Then your query should be:

select SUM(no)
from table
where no between 2 and 4

Note: In the select clause , you can not add other individual column( e.g name) since it's an aggregate function.

Sanjeeb Lenka13y ago

cast is used to convert one datatype to other datatype.

may be i am confused about your problem 1st. you can use an aggregate function to do that

ex:if age field is integer

select SUM(age) as totalage
from table
where no between 2 and 4

or if age field in varchar use this

select SUM(cast(age as int)) as totalage from table
where no between 2 and 4

Nandhini Jayachandran13y ago

let me know why you have used cast and +20 ... please explain

Nandhini Jayachandran13y ago

i dnt want to update table sir .i want to add the value of the age column which is between the no row 2 to 4

Hemant Srivastava13y ago

Try this:

UPDATE table
SET no = no + 20
where no between 2 and 4