SQL subtraction

[NeilV]

Hello...

I have a table which has a field that holds an integer value. What I want to do is calculate the difference(ie
subtract) of this field for my selected records. eg

ID       Value
----------------
1         30
2         10

Get the difference of value between record 1 and record 2 (30-10=20)
I thought this would be pretty simple, but I cant figure it out!

Help!
Neil

 

[maswien]

select t2.value - t1.value
from mytable t1, mytable t2
where t1.id = 1 and t2.id = 2

 

[NeilV]

Thanks mija! That did the trick! :-D