Select

Hello Smart Guys,

I have to retrieve data from a table ( my_table), which has 2 columns, year and count

Select year1.count ,
year1.count-year2.count
From my_table year1,my_table year2;

I tried union but I do not get all the info.

Thanks

Donna

I don't understand. Your subtracting what year from what year?

The idea is to substact 2 rows from the same table

col1
------
row1
row2


select col1.row1- col1.row2
from my_table;