Two rows arthimetic

[logic4fun1]

All,
I am trying to do the following but nothing strikes to me..

Here is the table data

A1,A2,A3,24
A1,A2,A3,30
B1,B2,B3,46
B1,B2,B3,60


How can i subtract two rows and get data like
A1,A2,A3,6
B1,B2,B3,14

Thanks for your help
logic4fun

 

[unclejimbob]

Given your data this works.

create table test(cola char(2), colb char(2), colc char(2), colnum int);
insert into test values('A1','A2','A3',24);
insert into test values('A1','A2','A3',30);
insert into test values('B1','B2','B3',46);
insert into test values('B1','B2','B3',60);

select cola,colb,colc,max(colnum)-min(colnum) from test group by cola,colb,colc

Anyone else got a better/more elegant solution ?

ujb

 

[Fahtrim]

Substr & concat? is this always fixed width?