Multiply same column being fetched in two similar select statements

[Rajarshi Roy]

I need to multiply the integer values in a column being fetched using two different select statements on one table.Can I do this using a select statement only?

As for example,I am doing :

select value from test_table where config_id = 2 order by test_id; (test_id being surrogate key, auto-incremented)

AND

select value from test_table where config_id = 4;

Now I want to do an opertation that will multiply the value field row-wise.

Can someone help me with this?