Sql query

Question

My database is like this

no name age

1 nan 23

2 nad 10

3 mam 10

4 rgh 10

5 hui 21

i want to add age which is between the no 2 to 4

result will be 30 .

This is query to retrieve data between 2 to 4

Select * from table where no between 2 and 4 but i dnt know how to add the age value ..please say query for this

Hemant Srivastava · 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 Lenka · Answer

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 Jayachandran · Answer

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

Nandhini Jayachandran · Answer

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 Srivastava · Answer

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