[erus]

hi guys;i m about to flip out.Here is my problem;
i want to extract two specific values from a column,to illustrate simply;

name value
a 10
b 20
c 30
d 40

what i wanna do is just to perform this function;
a+b-(c+d)
i know it seems so simple but i haven't make it work yet. thanks for your help by now

This post has been edited by erus: 29 March 2009 - 01:51 PM

[P4L]

This should help.

Select *
From Table
Where a+b-(c+d) as Value

[erus]

thx for try but its not so simple:)
you didn't indicate where a,b,c,d come from.let me explain my tought;
select sum(value) from table1 where name="a" or name="b"-select sum(value) from table1 where name="c" or name="d"

but it doesnt work..

This post has been edited by erus: 29 March 2009 - 11:52 PM

[erus]

i m waiting for your remarks..
it is not so hard

This post has been edited by erus: 31 March 2009 - 12:55 PM

[cardographer]

Something like...

select a.value+b.value-(c.value+d.value)
from tbl a, tbl b, tbl c, tbl d
where a.name = 'a' and b.name = 'b' and c.name = 'c' and d.name = 'd'

[ahmad_511]

hello,
you can use sub queries for this
assuming your table called tbl

select
(select value from tbl where name='a')+(select value from tbl where name='b')
-
(
(select value from tbl where name='c')+(select value from tbl where name='d')
)

hope it helps

[baavgai]

Not the ideal problem for a database. Still, in SQL, I'd probably do this:

select 
	sum(case when name='a' then value else 0 end)
	+ sum(case when name='b' then value else 0 end)
	- ( 
		sum(case when name='c' then value else 0 end)
		+ sum(case when name='d' then value else 0 end) 
	) as result
	from table
	where name in ('a','b','c','d')

This post has been edited by baavgai: 02 April 2009 - 06:38 PM

[erus]

baavgai, on 2 Apr, 2009 - 05:38 PM, said:

Not the ideal problem for a database. Still, in SQL, I'd probably do this:

select 
	sum(case when name='a' then value else 0 end)
	+ sum(case when name='b' then value else 0 end)
	- ( 
		sum(case when name='c' then value else 0 end)
		+ sum(case when name='d' then value else 0 end) 
	) as result
	from table
	where name in ('a','b','c','d')