i have 2 columns in a table
ED EF
(numeric) (numeric(7,4))
1 44.23
2 55.39
3 44.25
4 33.78
the outut should be displayed as
col1 col2 col3 col4 col5
1 44.23 2 55.39 difference of col2 and col4
2 55.39 3 44.25 difference of col2 and col4...
and same for other values..
How do i display output in this format.
Kindly help.