[Student7574]

I know how to use sum sql, but i dont know how to display it result in jsp page.
For example, my table database like this:

TableName: user
|userid|name|salary|
|1000 |john|500 |
|1001 |joe |600 |
|1002 |jim |700 |

so my sql statement like this, SELECT SUM(salary) FROM user WHERE userid=1000,1001. So the result
is 1100.

So the problem is, how i can display the result in jsp page..Someone help me please..

[Dormilich]

I assume your SQL query would fail (or not output what you expect), the WHERE clause is odd.

[JackOfAllTrades]

Moved to JavaEE

[Student7574]

Dormilich, on 10 July 2011 - 04:07 AM, said:

I assume your SQL query would fail (or not output what you expect), the WHERE clause is odd.

what is the correct statment if i want to get the result?

[shadowBean]

Student7574, on 10 July 2011 - 11:23 PM, said:

Dormilich, on 10 July 2011 - 04:07 AM, said:

I assume your SQL query would fail (or not output what you expect), the WHERE clause is odd.

what is the correct statment if i want to get the result?

SELECT SUM(salary) FROM user WHERE userid IN (1000,1001);

When you get the result you have to name the column as

new String(rs.getString("SUM(salary)").getBytes("utf8"), "UTF-8");

[Student7574]

Its work. thanks shadowBean